SQL Session – Inside SQL Server 2008 Resource Governor

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.

By Shannon Lowder

Shannon Lowder is the Database Engineer you've been looking for! Look no further for expertise in: Business Analysis to gather the business requirements for the database; Database Architecting to design the logical design of the database; Database Development to actually build the objects needed by the business logic; finally, Database Administration to keep the database running in top form, and making sure there is a disaster recovery plan.

Leave a comment

Your email address will not be published. Required fields are marked *