Databases Reference
In-Depth Information
10
Viewing Server Performance
with PerfMon and the PAL Tool
WHAT'S IN THIS CHAPTER?
➤
When and how to use Windows Performance Monitor
➤
Prescriptive guidance on problem counters
➤
Using PAL for log analysis
➤
Using other log analysis tools
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
There are no code downloads for this chapter.
INTRODUCTION
Performance Monitor, often referred to as PerfMon, is a tool that provides performance data
useful for narrowing the scope of a problem. This data is frequently used as a i rst point of call
for troubleshooting — providing server-wide diagnostics information, PerfMon can be used to
eliminate components as the cause of a problem.
PerfMon is often used interactively to provide a real-time view of server performance and
resource utilization (such as CPU, memory, and disk activity). PerfMon may also be useful for
post-mortem analysis, whereby logs can be coni gured to record data continuously, rollover, or
start/stop at specii c intervals. DBAs often i nd the tool useful when troubleshooting intermit-
tent problems or identifying a problem outside SQL Server (either a hardware problem or a
Windows issue).
Search WWH ::
Custom Search