Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

SQL Server 2008 Resource Governor in action

SQL Server 2008 Resource Governor in action

  • Comments 6
  • Likes

One of the biggest headaches in SQL Server 2005 is trying to manage resources where there are competing workloads on a shared server. A typical approach is to use instances, but this completely hides memory and CPU from other instances which are then not available to an instance under stress whether the other instances are using them or not.

The resource governor in SQL Server 2008 fixes that and I have a short blogcast here on TechNet Edge to demo how this works...

 image

Comments
  • Any chance I can get a copy of the code, etc, used in this recording so I can use it for a presentation I am creating for user groups and code camps in my area??  Please email me kgboles a t earthlink dt net

  • I am going to look into whther I can get this on codeplex, in the meantime, e-mail (afryer@microsoft.com) me and I'll see what I can do.

  • I came across this post in Andrew Fryer's blog, which has a short demo of the SQL Server 2008 resource

  • It looks like your "SQL Server 2008 Resource Governor in Action" video got highjacked.  I found it very useful and wanted to watch it again,but I am re-routed to some other website now.  Can you please see what can be done to have the link take me to the right place?  Thanks.

  • It was nice article. May I know where do I get Resource Governor Loads GUI which you have showed us on the demo?

  • Praveen

    That application was written internally, and I don't think I can give it out, so sorry about that

    Andrew

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