SQL Server 2019 is now here!
Get industry-leading performance, availability, and security on the platform of your choice, including Windows, Linux, and Docker. Build intelligent applications using your preferred language and environment. Gain real-time intelligence and deliver insights through modern analytical models and reports.
The most affordable way to get SQL, this option is great for small (1 – 30) users or devices.
SQL Server Standard Edition sets the bar for rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts.
Industry-leading performance, availability, and security
Get industry-leading performance, availability, and security on the platform of your choice, including:
Your choice of language and platforms
Build modern applications using the language of your choice, on-premises and in the cloud, now on Windows, Linux and Docker containers.
Take advantage of breakthrough scalability, performance, and availability for mission-critical, intelligent applications and data warehouses.
Least vulnerable database
Protect data at rest and in motion with the least vulnerable database over the last seven years in the NIST vulnerabilities database.
Gain transformative insights for your business with real-time analytics at up to 1M predictions/second.
End-to-end mobile BI
Turn raw data into meaningful reports that can be delivered to any device—at one-fifth the cost of other self-service solutions.
Hardware and Software Requirements:
SQL Server 2019 Standard DBE capacity limits
Max compute capacity
Lesser of 4 sockets or 24 cores
Max DB Size
Max memory utilization – DBE
The following requirements apply to all SQL Server 2019 installations:
o SQL Server 2017 require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server 2019 setup automatically installs .NET Framework. You can also manually install .NET Framework from Microsoft .NET Framework 4.6 (Web Installer) for Windows.
Windows 10, and Windows Server 2016:
o Require KB2919355 before installing .NET Framework 4.6.
Supported operating systems for SQL Server 2019 have built-in network software.
o Note: Shared memory and VIA are not supported on failover clusters.
- Also note that the VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
o SQL Server 2019 requires a minimum of 6 GB of available hard-disk space.
- Disk space requirements will vary with the SQL Server 2019 components you install.
o A DVD drive, as appropriate, is required for installation from disc.
o SQL Server 2019 requires Super-VGA (800×600) or higher resolution monitor.
o Internet functionality requires Internet access (fees may apply).
The following memory and processor requirements apply to all editions of SQL Server 2019:
o 512 MB
All other editions:
o 1 GB
o 1 GB
All other editions:
o At least 4 GB and should be increased as database size increases to ensure optimal performance.
o Minimum: x64 Processor: 1.4 GHz
o 2.0 GHz or faster
o x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support.