SQL Server 2019 Requirements:
The minimum requirements to install SQL Server 2019 on windows server operating system.
Requirements for Hardware:
SQL Server needs a minimum of 6GB available on the disk where SQL is being installed and the disk requirements will vary based on the Components you selects while installing
It requires a minimum of 1GB RAM but microsoft recommends to have minimum 4GB RAM and it also depends on the database size we may need to increase the RAM for better performance.
Note : SQL Server installation supports on x64 processor only.x86 is no longer supported by MS.
Requirements for Software :
SQL Server 2019 requires a minimum operating system of Windows Server 2016/ Windows Server 2019
It requires a .NET Framework 4.6.1 which will come pre-installed on Windows Server 2016/ Windows Server 2019
Also better to have .NET Framework 3.5 installed as Database Mail requires this.
Supported Operating systems for SQL Server 2019 :
SQL Server 2019 Supported Editions
Ent | Dev | Stan | Web | Express | |
Windows Server 2019 Enterprise | YES | YES | YES | YES | YES |
Windows Server 2019 Standard | YES | YES | YES | YES | YES |
Windows Server 2019 Datacenter | YES | YES | YES | YES | YES |
Windows Server 2016 Enterprise | YES | YES | YES | YES | YES |
Windows Server 2016 Standard | YES | YES | YES | YES | YES |
Windows Server 2016 Datacenter | YES | YES | YES | YES | YES |
Support on Server Core Operating System:
SQL Server 2019 installing on Server Core operating system is supported by below Windows Servers :
Windows Server 2016 Core Edition
Windows Server 2019 Core Edition
SQL Server 2019 Installation Media file can be downloaded from below link :
https://www.microsoft.com/en-in/evalcenter/evaluate-sql-server-2019
Page File Configuration :
To get a memory dump for future analysis , servers are configured by setting a pagefile with 1.5 times of Memory (1.5*Physical Memory ) .
Disk Volumes Details:
For high I/O behavior of SQL and some application we need to consider disk performance. Data and Log volumes needs to be in separate volumes or separate disks.
Example:
Volume | Drive Mount Point | Size in GB | Disk Speed |
SQL DATA | G:\SQLDATA | 250 GB | FAST |
SQL LOGS | G:\SQLLOGS | 300GB | VERY FAST |
SQL TEMP LOG | G:\SQLTEMPLOG | 50GB | VERY FAST |
SQL TEMP DATA | G:\SQLTEMPDATA | 50GB | FAST |
SQL BACK | G:\SQLBACK | 500 GB | STANDARD |
Note : Mount point root Permissions does not inherit to the mount points . We need to explicitly copy those root permissions and set the same to the mount points.
Firewall Security :
TCP/UDP | PORT | Description |
TCP | 1433 | SQL Server/Availability Group listener ( Default Port can be changed ) |
TCP | 5022 | SQL Server DBM/AG endpoint ( Default port can be changed ) |
UDP | 1434 | SQL Server Browser |
UDP | 2382 | SQL Server Analysis Services Browser |
UDP | 2383 | SQL Server Analysis Services Listener |
UDP | 49152-65535 | Dynamic TCP\UDP ( Defined Policy or by Company ) |