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...

The sys.dm_os_wait_stats DMV provides essential metrics for diagnosing SQL Server performance problems. Returning incrementally accumulating information about all the completed waits encountered by executing threads it is a useful way to identify bottlenecks...

Here's a quick summary of SQLOS feature enhancements going into SQL Server 2012. Most of these are already in the CTP3 pre-release, except for the Resource Governor enhancements which will be in the release candidate. We've blogged about a couple of these...

A new Microsoft white paper has been published entitled Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations . This paper, based on performance testing in the SQL Cat teams labs, provides advice on best practices for SQL...

We've been seeing a lot of interest in optimizing SQL Server for virtualization private cloud deployment lately. Below is an attempt to put useful links to recent SQL Server virtualizaiton, consolidation and private cloud resources in one place, divided...

Following our last post by Mehmet about new support and troubleshooting DMV’s, here are additional details on supportability DMV changes in SQL 2008 R2 SP1 and how you might use them. These changes are also available in “Denali”, the...

This article is about some of the new DMV’s that are newly added to next version of SQL Server. These are also available SQL Server 2008 R2 SP1. They are very helpful to get information about the host operating system that the SQL Server runs on...

In parts 1 and 2 of this series we looked at the basics of Hyper-V Dynamic Memory and SQL Server memory management. In this part Serdar looks at configuration guidelines for SQL Server memory management. Update 8/2/11 : please also refer to the recently...

Part 1 of this series was an introduction and overview of Hyper-V Dynamic Memory. This part looks at SQL Server memory management and how the SQL engine responds to changing OS memory conditions. Part 2: SQL Server Memory Management As with any...

SQL and Dynamic Memory Blog Post Series Hyper-V Dynamic Memory is a new feature in Windows Server 2008 R2 SP1 that allows the memory assigned to guest virtual machines to vary according to demand. Using this feature with SQL Server is supported...

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...

The next version of SQL Server will contain significant changes to the memory manager component. The memory manager component has been rewritten for Denali. In the previous versions of SQL Server there were two distinct memory managers. There was one...

One of the philosophical principles of hardware virtualization is that the hardware should appear "real" to a virtualized operating system. One could generalize this to a principle of emulation - the emulated entity should not be "enlightened" to the...

The Dynamic Management Views (DMVs) introduced in SQL Server 2005 provide a comprehensive window into the state of the SQL engine and also the machine it is running on. This post will look at how the SQL Server process uses DMVs to keep track of its own...

A new white paper has been published on TechNet today: Planning, Implementing and Supporting SQL Server Virtualization with Windows Server 2008 R2 Hyper-V and Live Migration . Written by Shirmattie Seenarine and Ross Mistry the article goes into detail...

Violin Memory have published an interesting TPC-E benchmark which illustrates the kind of cost and performance gains that can be achieved by strategically replacing traditional disk drive arrays with solid state memory systems. Replacing storage with...

Hello, I recently joined the SQLOS team as a program manager. As it has been a year or so since the SQLOS team blog was active, now seems like a good time to step back and look at how the SQLOS component and sub-components fit into SQL Server architecture...

Xevent related system catalog views and DMVs Some one asked me how to use xevent. There are lot of system catalog views and DMVs that you can query. Here I will give you a brief introduction of those catalog views and DMVs and the SQL script that we...

My Experience on using RPC in mixed mode assembly I was assigned a project which use RPC cross unmanaged world (from SQL Server code) to managed world (test c# code). The main idea is transferring event data from SQL Server to test application...

We add extended event (short for XEVENT) to SQL Server 2008. Along with this feature, we provide a set of system catalog views and DMVs to allow user to monitor extended event objects and sessions. For the usage of XEvent, please check the online help...

[Copied over from my original blog http://ssinghal.spaces.live.com to have everything under one roof] One of most basic component in SQLOS is memory object. Every introduction to memory object (refer http://blogs.msdn.com/slavao/archive/2005/02/11...

[Copied over from my original blog http://ssinghal.spaces.live.com to have everything under one roof] Recently a customer wanted to know some details on how SqlServer manges memory, sort of the basics. Presented below is some of the starter resources...

We work in Microsoft Sql Server team for one of the core components called SQLOS. Thats the place where everything comes together (or where everything starts out...depending on how you are looking at the callstack :-) We'll talk more about our product...