Debugging slow response times in SQL Server 2008

Introduction The other day I came across a nice article written by Mario Broodbakker called “SQL Server Wait Events: Taking the Guesswork out of Performance Profiling” (see references) on how to troubleshoot slow response times in SQL Server 2000 and 2005 using the YAPP Method. According to the author, one of the biggest challenges to apply…


Part 1: Anatomy of SQL Server 2008 Resource Governor CPU Demo

First, a quick introduction. My name is Boris Baryshnikov and I’m a program manager in SQL Server Database Engine group. As of today, Resource Governor is the most recent large project I worked on. Not surprisingly, I will talk about the Resource Governor here. While Resource Governor spans multiple components of SQL Server Engine, it…


Part 2: Resource Governor CPU Demo on multiple CPUs

In some cases CPU demo described in the previous post may behave not as expected. One such case is doing the demo on multiple CPUs. Even though it appears as Resource Governor is “not working”, it is “by design”. Let’s take a look at what happens in this case. What is our promise about CPU…


How to configure Soft-NUMA on a system with > 32 processors?

  I recently answered this customer question and was looking forward to post the solution here. So here you go! There is already a lot of information about how Soft NUMA works and how to configure Soft NUMA on your system. So without delving into the basics, I am jumping right ahead to the topic.  …


SQLOS Team blog updates

Please note that to save the need to check two different sites, future SQLOS team blog posts will be appearing on the MSDN site here: SQLOS Team Blog. Thanks, Guy.