SQL Server 2019 Requirements for Server Side and SQL Side

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

EntDevStanWebExpress
Windows Server 2019 EnterpriseYESYESYESYESYES
Windows Server 2019 StandardYESYESYESYESYES
Windows Server 2019 DatacenterYESYESYESYESYES
Windows Server 2016 EnterpriseYESYESYESYESYES
Windows Server 2016 StandardYESYESYESYESYES
Windows Server 2016 DatacenterYESYESYESYESYES

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:

VolumeDrive Mount PointSize in GBDisk Speed
SQL DATAG:\SQLDATA250 GBFAST
SQL LOGSG:\SQLLOGS300GBVERY FAST
SQL TEMP LOGG:\SQLTEMPLOG50GB VERY FAST
SQL TEMP DATAG:\SQLTEMPDATA50GBFAST
SQL BACKG:\SQLBACK500 GBSTANDARD

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/UDPPORTDescription
TCP1433SQL Server/Availability Group listener ( Default Port can be changed )
TCP5022SQL Server DBM/AG endpoint ( Default port can be changed )
UDP1434SQL Server Browser
UDP2382SQL Server Analysis Services Browser
UDP2383SQL Server Analysis Services Listener
UDP49152-65535Dynamic TCP\UDP ( Defined Policy or by Company )

Author: Sri

Hello Friends, This blog is to help the IT professionals who want to become a professional SQL Server DBA but don't know how and from where to start with. So, I am going to share my experiences and my learning in this blog. Will talk about what are the pre-requisite skills required to become a Professional SQL Server DBA, how much time it takes to be a good DBA and what are the additional skill sets are required to become a good DBA. Apart from that I will also post real time sql server settings on server level and database level, Configuring High Availability. Also will share the Client requirements with real time setups if possible I will provide you with screenshots.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.