Browse by Tags

• Affinity
• Resource Governor
• Soft NUMA
• SQLOS

• 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, Read More... Posted Friday, May 15, 2009 11:10 PM by harshiam | 0 Comments Filed under: Affinity, SQLOS, Soft NUMA

• 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 Read More... Posted Friday, July 18, 2008 11:56 PM by IvanPe | 2 Comments

• 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. Read More... Posted Friday, January 18, 2008 8:00 PM by BorisB | 1 Comments Filed under: Resource Governor

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

  This post is a step-by-step walkthrough of SQL Server 2008 Resource Governor CPU demo Read More... Posted Friday, December 14, 2007 12:19 PM by BorisB | 2 Comments Filed under: Resource Governor