Memory Manager Configuration changes in SQL Server 2012

Continuing from yesterday’s article about Memory Manager surface area changes in SQL Server 2012, this post looks at corresponding configuraton changes for the new Memory Manager. The surface area change article mentioned  that the Memory Manager redesign resulted in being able to more accurately size and govern all SQL Server memory consumption. Let’s look at what this…


Memory Manager surface area changes in SQL Server 2012

There were various changes to memory related DMVs, DBCC memory status, and Perfmon counters in SQL Server 2012 as part of the redesign of the Memory Manager component of SQLOS. The Memory Manager redesign resulted in being able to more accurately size and govern all SQL Server memory consumption, making page allocations more efficient, and better…


What causes Multi-Page allocations?

Writing about changes in the Denali Memory Manager In his last post Rusi mentioned: ” In previous SQL versions only the 8k allocations were limited by the ‘max server memory’ configuration option.  Allocations larger than 8k weren’t constrained.” In SQL Server versions before Denali single page allocations and multi-Page allocations are handled by different components, the…