SQL Server edition memory usage : Smart-Acc e-Support

How can we help you today?

SQL Server edition memory usage Print

Modified on: Thu, 27 Apr, 2023 at 11:18 PM

SQL Server edition memory usage

Print screen:

Here is what some versions of SQL Server support for memory.

SQL Server 2000: 2GB Standard, more with Enterprise.
SQL Server 2005 : 32GB Standard, 1TB Enterprise.
SQL Server 2008 : 32 GB, Enterprise 1TB.
SQL Server 2008 R2 : 64GB standard, Enterprise 2TB.
SQL Server 2012 : 64GB Standard, operating system max for Enterprise.
SQL Server 2014 : 128GB Standard, operating system max for Enterprise.
SQL Server 2016 : 128GB Standard, operating system max for Enterprise.
SQL Server 2017 : 128GB Standard, operating system max for Enterprise.
SQL Server 2019 : 128GB Standard, operating system max for Enterprise.

Ref: https://stevestedman.com/2022/01/sql-server-memory-limits/

Did you find it helpful? Yes No