SQL Server 2019 Requirements:
the necessary conditions for installing SQL Server 2019 on Windows servers.
Requirements for Hardware:
- The disk space requirements for SQL Server will vary depending on the components you choose when installation, with a minimum of 6GB needed on the drive where SQL is being installed.
- It needs at least 1GB of RAM, although Microsoft advises 4GB, and depending on the size of the database, we might need to increase the RAM for better performance.
- Note that only x64 processors are supported for SQL Server installation. MS no longer provides support for x86.
Requirements for Software:
- Windows Server 2016 or Windows Server 2019 is the minimal operating system requirement for SQL Server 2019.
- It needs the.NET Framework 4.6.1, which Windows Server 2016/Windows Server 2019 will have already installed.
- Additionally, it is preferable to have.NET Framework 3.5 installed because Database Mail needs it.
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:
The following Windows Servers are compatible with installing SQL Server 2019 on Server Core:
Windows Server 2016 Core Edition
Windows Server 2019 Core Edition
You may obtain the SQL Server 2019 Installation Media file from the following link:
https://www.microsoft.com/en-in/evalcenter/evaluate-sql-server-2019
Page File Configuration:
Servers are configured by setting a pagefile with 1.5 times of memory (1.5*Physical Memory) to obtain a memory dump for upcoming examination.
Disk Volumes Details:
Disk performance must be taken into account for SQL and some applications that exhibit high I/O behavior. Data and log volumes must be on different disks or volumes.
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 mount points do not inherit from mount point root permissions. These root permissions must be manually copied and set 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) |