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 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.
