Professional SQL Server® 2012 Internals and Troubleshooting by unknow

Author:unknow
Language: eng
Format: epub
Published: 0101-01-01T00:00:00+00:00

268 ❘ CHAPTER 10 VIEWING SERVER PERFORMANCE WITH PERFMON AND THE PAL TOOL

Getting Started with PerfMon

PerfMon is a component of Reliability and Performance Monitor which can be launched from Start

➪ All Programs ➪ Administrative Tools. Alternatively, just type perfmon into the Run box and press Enter.

As mentioned earlier, PerfMon is a Windows monitoring tool, and as such it can be used to monitor any application — from Microsoft Exchange to Windows itself. When an application is installed,

performance counters are registered and you can monitor the counters in real time or trace them

to a log fi le. PerfMon isn’t designed specifi cally for SQL Server, so you need to add the relevant Windows and SQL Server counters to a log fi le in order to view resource utilization and SQL Server activity.

Monitoring Real-Time Server Activity

One of the most common uses for PerfMon is viewing real-time server activity. PerfMon provides

data instantly on system workload, performance, and resource consumption. By reading the data

presented by PerfMon, you can rapidly narrow the scope of a problem.

Within Reliability and Performance Monitor, select Performance Monitor from the Monitoring

Tools folder. You’ll be presented with a line chart plotting percentage of processor time from your own computer, as shown in Figure 10-2. In this section, you’ll add a few counters to get a feel for CPU, disk, and memory activity on your PC.

FIGURE 10-2

c10.indd 268

10/3/2012 3:36:52 PM

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.