If you’re not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server.
In this presentation, Aaron Bertrand will provide an overview of Resource Governor, a new feature in SQL Server 2008 that will give DBAs and system administrators much more granular control over how CPU and memory are used by SQL Server. He will explain how you can leverage SQL Server 2008’s Resource Governor not only for preventing the “runaway query” but also for prioritizing workloads, testing consolidation approaches, meeting service level agreements, and configuring a charge back system. Aaron will also provide information about what you cannot or should not do with Resource Governor. This presentation is the basis of an upcoming white paper to be published soon.