http://blogs.technet.com/andrew/archive/2008/02/06/sql-server-2008-resource-governor-in-action.aspxOne 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 thenen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.technet.com/andrew/archive/2008/02/06/sql-server-2008-resource-governor-in-action.aspx#2859742Sun, 10 Feb 2008 05:16:38 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:2859742Kevin Boles<p>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?? &nbsp;Please email me kgboles a t earthlink dt net</p>http://blogs.technet.com/andrew/archive/2008/02/06/sql-server-2008-resource-governor-in-action.aspx#2863544Sun, 10 Feb 2008 21:16:44 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:2863544Andrew_Fryer<p>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.</p> http://blogs.technet.com/andrew/archive/2008/02/06/sql-server-2008-resource-governor-in-action.aspx#2875561Tue, 12 Feb 2008 12:37:20 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:2875561Rob's SQL Server Blog<p>I came across this post in Andrew Fryer's blog, which has a short demo of the SQL Server 2008 resource</p>