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

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…

4