Seminar - SQL Server 2008
On Demand Webcast: SQL Server 2008 Resource Governor10/15/2008
Webcast Archive: SQL Server 2008 Resource Governor: What it is and how to use it SQL Server 2008 introduces a new feature called Resource Governor which enables Database Administrators to manage SQL Server workload and critical system resource consumption. Resource Governor helps DBAs deliver more predictable performance by specifying limits on the amount of CPU and memory which the incoming sessions to the SQL Server can use. In a production environment, DBA's may see a sudden spike in CPU and memory utilization -- which then slows responses to query requests. These issues happen because there is unpredictable workload execution like long running TSQL queries, database backups being performed, among other things. Resource Governor offers a solution to these issues by allowing DBAs to differentiate workloads and allocate shared resources as they are requested, based on defined limits for resources like CPU and memory.
In this webcast, SQL Server MVP Hilary Cotter, discusses how to use Resource Governor, how to monitor governed workloads and pools, and how to estimate the memory and CPU settings for each workload. |
