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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.