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…

7

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…

2