11.2. Tune SQL Server
After you have gathered a good sample of monitoring information, it's time to put it into practice. Improving performance of a SQL Server instance is referred to as tuning.
11.2.1. Using Resource Governor
Resource Governor is new to SQL Server 2008 and enables you to manage SQL Server workload and resources by specifying limits on resource consumption by incoming requests. Resource Governor defines a workload as a set of similarly sized queries that can and should be treated as a single unit. Although uniformity of your resource usage pattern is not required, it will likely give you more benefit from Resource Governor. The limits that you create for Resource Governor can be reconfigured in real time with minimal impact ...
Get SQL Server® 2008 Administration: Instant Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
