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...
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