Using SQL Server Resource Governor to Control Resource Utilization

This article introduces SQL Server Resource Governor and provides a detailed walkthrough of using Resource Governor to manage the resource utilization of SQL Server.

Resource Governor Calculations

Monitoring Resource Governor Memory Grants

A very useful query that will allow you to monitor the resource governor memory grants along with other useful information.

Resource Governor defaults

How the Resource Governor Helped Our Report Server

Trying to manage the load in a reporting server can be hard. Roy Ernest shows that Resource Governor might be a great solution that has worked in his environment.

Handling workloads on SQL Server 2008 with Resource Governor

SQL Server 2005 resource allocation policies treat all workloads equally, and allocate shared resources as they are requested. It sometimes causes a disproportionate distribution of resources, which in turn results in uneven performance or unexpected slowdowns whereas the new Resource Governor of SQL Server 2008 allows organizations to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to the end users.

Resource Governor in SQL Server 2008

This article describes how Database Administrators can manage SQL Server workload and critical system resource consumption using Resource Governor in SQL Server 2008

Resource Governor

This article is about Resource Governor. A new feature introduced in SQL Server 2008. Special focus is placed on the T-SQL implementation of the new feature.

Resource Governer

Resource Governor