Sql server 2016 max server memory

by Pisit Changmai   Last Updated January 12, 2018 12:06 PM

Does max server memory for sql 2016 contain buffer pool plus in-memory columnstore plus in-memory oltp and etc cache?

Tags : sql-server


Answers 2


Please visit https://blogs.msdn.microsoft.com/sql_server_team/sql-server-2016-sp1-know-your-limits/ There are exact explanations about the memory limits especially in confunction with SQL Server 2016 SP1.

Christian Gräfe
Christian Gräfe
January 12, 2018 11:55 AM

I believe it depends on what you set max memory to, what is available on the host, and what edition you have. Aaron Bertrand wrote a good blog post on exactly this:

https://sqlperformance.com/2016/12/sql-server-2016/memory-limits-sp1

To try and answer your question, "If the server has less than 128GB, you will see these technologies compete with buffer pool memory, and in fact be limited to a % of max server memory."

DimPerson
DimPerson
January 12, 2018 11:59 AM

Related Questions


Linked Server Error on SQL Agent Job

Updated March 16, 2016 08:02 AM