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.
This recipe extends our previous recipe and assumes that you have already completed previous recipes in this chapter. ...