SQLOS and Cloud Infrastructure sessions at PASS Summit 2012

The SQL Pass Summit 2012, the largest yet, is in full swing. Here’s a summary of the sessions this week on cloud infrastructure and SQLOS topics. Some of these were today, and you can catch the recordings. One more session takes place on Friday covering SQL Server solution patterns in Windows Azure VMs… Also, catch Thursday’s keynote with…

0

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…

2

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…

6

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…

3

SQL Server 2012 Memory Manager KB articles

Since the release of SQL Server 2012 with a redesigned memory manager, a steady stream of KB articles have been produced by CSS to provide guidance on the new or changed options, as well as fixes that have been published..   How has memory sizing changed in SQL 2012? 2663912 Memory configuration and sizing considerations in…

4

Lock Pages in Memory – not deprecated in Denali

Please note an error in the SQL 2012 documentation for Lock Pages in Memory which indicates that it’s deprecated. It’s not. Locking pages in memory is a useful feature and there are no plans to deprecate it. It looks like it was accidently included on this page when we made changes to deprecate AWE. So.. keep…

0