Databases Reference
In-Depth Information
Getting ready
Before you continue with this recipe, you should know what data the Processor:% Processor
Time and System:Processor Queue Length performance counters gather.
Processor:% Processor Time: This provides the percentage of CPU time that has been used
by a thread. Remember that if you have multiple CPUs or multiple CPU cores installed on your
system, you will find multiple instances of this performance counter. For example, if you have
two Intel Xeon processors installed on your machine with four CPU cores on each processor,
then you will have a total of 8 instances of this performance counter. You can add this counter
either for all CPU/core instances or for a specific CPU/core instance.
System:Processor Queue Length: This provides you with the number of threads that are
waiting for their turn to use the CPU.
The following are the prerequisites for this recipe:
F
An instance of SQL Server 2012 Developer or Enterprise Evaluation edition
F
Performance Monitor, as installed with Windows OS
How to do it...
To monitor CPU usage statistics, follow the steps given here:
1. To start Reliability and Performance Monitor, press the Windows +
R
key
combination to display the Run dialog box. In this dialog box, type perfmon.exe
and press
Enter
.
2. When Reliability and Performance Monitor is started, to switch to Performance
Monitor view, click the Performance Monitor node under the Monitoring Tools
node in the left-hand-side console tree.
3.
Press the
Delete
key or click on the X button in the toolbar to delete any existing
performance counter. Click on the + button in the toolbar to add counters.
4.
In the Add Counters dialog box, type the name of the computer that you are going to
monitor, or let it be <Local computer>, if you are monitoring a local machine under
the Select counters from computer: drop-down list.
5.
In the list of available performance counter objects, expand Processor and select
% Processor Time.
Search WWH ::
Custom Search