Using the Resource Governor

This paper covers the new Resource Governor feature introduced in SQL Server 2008, including ways of using it for server consolidation, preventing runaway queries, meeting service level agreements and implementing a resource usage based charging system ... Source : Whitepaper - MSDN.com

Resource Governor Demystified

Arguably one of the most significant new features in 2008, Resource Governor brings with it a fair amount of confusion. In this post, Bob Dorr addresses some of the common misunderstandings, including why a process can exceed its maximum CPU usage ... Source : Bob Dorr - PSS SQL Server Engineers - Blog Post

Resource Governor Q&A

The SQL Server PSS Engineers answers some common questions about the new Resource Governor tool and provide some best practices regarding its use ... Source : MSDN Blogs - PSS SQL Server Engineers - Blog Post

Inside Resource Governor

In this post, Boris takes us through the setup and execution of a Resource Governor demo, and in doing so, exposes some of the nuances of how it works ... Source : Boris Baryshnikov - Technet.com - Blog Post

Understanding how Resource Governor throttles CPU usage involves understanding process scheduling. Boris explains … ... Source : Boris Baryshnikov - Technet.com - Blog Post

Resource Governor

SQL Server 2008 Resource Governor allows much more control over resources compared to SQL 2005. In this blog post from ScalabilityExperts, the feature is demonstrated through examples and compared to the closest options available in SQL 2005 ... Source : ScalabilityExperts.com - Blog Post

APP_NAME() Spoofing

Both Resource Governor and Logon triggers can use the APP_NAME() function to categorize incoming connections and take appropriate action (deny/classify etc …), however, someone with access to the connection string (and knowledge of the logon trigger/classification logic) can spoof the Application Name value to circumvent the desired action ... Source : Jens Suessmeyer - MSDN.com - Blog Post