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

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

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