There's Something about SQL!

...SQL Server, BI and other Cool Technology... var sc_project=1839145; var sc_invisible=1; var sc_partition=17; var sc_security="180bc290";

Resource Governor Demos

Resource Governor Demos

  • Comments 1
  • Likes

If you are looking for some demos to play and learn about Resource Governor, you should have a look to the SQL Server SQLOS team blog, which has posted a couple of interesting ones.

 

1) Anatomy of SQL Server 2008 Resource Governor CPU Demo

http://blogs.technet.com/sqlos/archive/2007/12/14/part-1-anatomy-of-sql-server-2008-resource-governor-cpu-demo.aspx

 

This demo will use a single CPU to simplify the concepts described, and will create 2 Resource Pools, one used from a single Workload Group and one shared between two Workload Groups. Everything will be initially configured with default parameters, but will then be changed to demonstrate the effects of restricting CPU utilization and the meaning of the importance option in the Workload Groups.

 

2) Resource Governor CPU Demo on multiple CPUs

http://blogs.technet.com/sqlos/archive/2008/01/18/part-2-resource-governor-cpu-demo-on-multiple-cpus.aspx

 

This demo will use two CPU and will demonstrate the fact that Resource Governor CPU limitations are applied only when there is actual contention on the scheduler. It will show the effect of having restricted CPU utilization and Workload Groups landing on different schedulers.

 

- Beatrice Nicolini -

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment