O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required