Viewing Server Performance with PerfMon and the PAL Tool - SQL Server 2012 Internals and Troubleshooting - page 286

You can download PAL from http://pal.codeplex.com .

After you have downloaded and opened PAL, the tabs located across the top of the utility act as
steps in the wizard. Navigating through each of these steps and populating the required information
is all that is necessary to process a PerfMon log. The following steps will help get you started
with PAL:

1.

Once installed, launch PAL from the Start menu. The Welcome page will be displayed, as
shown in Figure 10-8.

FIGURE 10-8

USING THE EXPORT FEATURE TO CREATE A LOG TEMPLATE

If you don't have an existing PerfMon log to analyze, consider exporting a threshold
i le to create a counter log template. To do this, choose the Threshold File tab from
the PAL interface, select the SQL Server 2005/2008 template, and click the Export
to PerfMon Template File button. Export the template with an .XML extension for
use on Windows 7 or Windows Server 2008 target machines.

2.

Select the Counter Log tab and browse to select the PerfMon log (see Figure 10-9).