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 CPU usage

The CPU is the most important resource on a server. On a database server, CPU usage should be monitored from time to time to make sure that the performance of the database server is optimized.

In this recipe, we will use Reliability and Performance Monitor to capture CPU-related usage statistics.

You may have used Performance Monitor (where you could add different performance counters that need to be traced) in the past. Reliability and Performance Monitor is an enhanced version of the old Performance Monitor tool. In Reliability and Performance Monitor also, we can use performance objects and counters to analyse system performance by different parameters.

Performance Counters provide statistical data for various system activities. ...

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