O'Reilly logo

Microsoft® SQL Server 2012 Management and Administration, Second Edition by Ross Mistry

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required