When working on different client servers, we often times get asked, why all their memory is not being used, and often times we are hitting the memory limits for SQL Server Standard Edition.
Keep in mind that this limit on memory is for the buffer pool and what is being used by databases. SQL Server can use more than this amount of memory for other areas. For instance other processes like SSRS or SSIS.
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.
The newer versions of SQL Server also make much better use of that memory.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!