Databases Reference
In-Depth Information
4.
On the Questions tab there are i ve additional questions to answer. Responding to these
questions will provide output with thresholds tailored to the server on which the PerfMon
log was captured. Ensure that you count logical processors, not physical sockets, when
choosing the number of CPUs.
5.
Click Next or choose the Analysis Interval menu item. Here you can control the interval
used by PAL to analyze the log i les. Selecting All from the drop-down box means PAL
will analyze every data point in the log i le (this could be very many) and analysis will be
lengthy. Leave this as Auto unless you have a specii c reason to change it.
6.
Click Next or choose the Output Options item from the menu bar. Here it's possible to con-
trol the output types and location. The default settings are usually good unless something
specii c is required.
7.
Move to the Execute tab, where usually the default settings are adequate. Click Finish to
begin log analysis, which will launch the script (see Figure 10-11).
FIGURE 10-11
Once the PAL tool has i nished, an MHT i le will be displayed in Internet Explorer containing the
results. To get an idea of what this process entails, a recent 254MB log i le analyzed by PAL on a
quad-core computer took around 45minutes to analyze.
The report produced by PAL analyzes performance metrics for the key hardware resources:
Processor, Network, Disk, Memory, and SQL Server. The report is color-coded to help you quickly
identify problem areas.
Search WWH ::
Custom Search