Chapter 18. Managing Workloads with Resource Governor

Resource Governor was a new management feature introduced in SQL Server 2008. It bolstered SQL Server performance by allowing DBAs to manage SQL Server workloads and system resource consumption by establishing resource limits and priorities on processor and memory-related workloads and resource pools. By defining resource limits on resource consumption, it was possible to prioritize multiple workloads to ensure consistent performance, maximize the experience of clients and applications, and improve the efficiency of the applications without performance degradation.

It is important for every DBA to know that Resource Governor throttles processes only if SQL Server is experiencing CPU or memory ...

Get Microsoft® SQL Server 2012 Management and Administration, Second Edition now with O’Reilly online learning.

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