Microsoft SQL Server 2012 Bible

Performance Monitoring of Resource Governor

You can check the performance through the Reliability and Performance Monitor. The two SQL Server performance monitors available are Resource Pool Stats (as shown in Figure 50.2).

Figure 50.2 Performance Monitor enables you to know how the resource pools function.

While using the Resource Governor, you must monitor the workloads inside each resource pool. You may find that a specific workload consumes all the resources of a resource pool. In that case you may want to place that workload in a different workload group in its own resource pool. Microsoft recommends that in planning for the Resource Governor you run all workloads in the default resource pool, each in their own workload group. This way you can determine the resource consumption characteristics of each workload and create appropriate resource pools for each workload, or place workload loads with similar resource consumption characteristics in their own workload group and resource pool.

For example, all reporting applications might be in a single resource pool, which limits their CPU consumption, and you can place all OLTP workloads into a different resource pool, which has a higher importance setting.