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.

Taking further the scenario of the web application and the reporting application in the context of monitoring Resource Governor, we will execute sample queries with login accounts AW_WebAppUser and AW_ReportAppUser, to simulate the scenario of...