Monitoring Resource Governor

After you are done with configuring Resource Governor as per your applications' resource requirements, you will need to monitor your Resource Governor. You may want to monitor how resource pools are utilized and how many session requests are routed to a particular resource pool. You may also want to monitor the internal and default pool activity.

In this recipe, we will execute required sample queries from different connections, with different logins (AW_WebAppUser and AW_ReportAppUser), and monitor the CPU and memory resource usage for each resource pool in Reliability and Performance Monitor.

Getting ready

This recipe extends our previous recipe and assumes that you have already completed previous recipes in this chapter. ...

Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with O’Reilly online learning.

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