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.

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

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

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

This post is a step-by-step walkthrough of SQL Server 2008 Resource Governor CPU demo...