Resource Governor in SQL Server 2012 technical article published

The SQL Server Technical article entitled Resource Governor in SQL Server 2012 has just been published. The article focuses on the SQL Server 2012 enhancements to the Resource Governor which reflect a growing need for centrally managed database services to support isolated workloads in multitenant environments. This document describes the enhancements and why they were added. It includes…


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…