Overview
Discover how to manage SQL Server resource consumption effectively in this conference talk from PASS Data Community Summit. Learn about the Resource Governor, an enterprise-level feature introduced in SQL Server 2008, which allows administrators to set limits on CPU, physical I/O, and memory usage for incoming application requests. Explore key concepts such as resource pools, work groups, and classification functions. Gain insights into preventing reporting activities from impacting critical business processes like sales. Understand the potential pitfalls and best practices for implementing Resource Governor in your environment. By the end of this hour-long presentation, acquire the knowledge needed to start using Resource Governor to control chaos and optimize database performance during peak business hours.
Syllabus
Controlling Chaos with Resource Governor - John Miner
Taught by
PASS Data Community Summit