Performance Analysis of Logs (PAL)

Views 1942

If you have ever needed the ability to analyse your SQL Server environment to determine where you may be having issues you will probably have used Performance Monitor to collect some performance counters. How do you easily look at the results from these trace logs and come up with a report to your managers?

You may have come across PAL in the past which is available from Codeplex. As of March 20 2012 a new version of PAL is available for download.

The key features are:

    • Thresholds files for most of the major Microsoft Products
    • Easy to use GUI
    • A GUI editor for editing your own threshold files
    • Creates HTML Based reports
    • Analyzes performance counter logs

PAL v2.3 is available for download from Codeplex.

Good luck with your performance analysis.

Leave a Reply

Your email address will not be published. Required fields are marked *


I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.