Subscribe in a reader" />
Welcome to TechNet Blogs Sign in | Join | Help

Andrew Fryer's Blog

Insufficient Data

News

SQL Server 2008 Resource Governor in action

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 to demo how this works...

 image

Posted: Wednesday, February 06, 2008 9:55 AM by Andrew_Fryer

Comments

Kevin Boles said:

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

# February 9, 2008 9:16 PM

Andrew_Fryer said:

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.

# February 10, 2008 1:16 PM

Rob's SQL Server Blog said:

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

# February 12, 2008 4:37 AM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker