SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

PAL 2.0 Beta Released

Back in 2008, I wrote a blog post about version 1 of the Performance Analysis of Logs (PAL) tool. This free tool, available from pal.codeplex.com, has been enhanced, and Version 2.0, Beta 1.1, is currently available for download. I have just downloaded and installed it myself, although I haven’t had much chance to use it yet. When I have time, I will write a review of the new version. In the meantime, I recommend you download it and give it a try. It’s a great tool for analyzing Performance Monitor Logs, and it is also a great source for determining which Performance Monitor counters, and thresholds, should be used when analyzing SQL Server’s performance.


Posted by Dukagjin Maloku on 3 July 2010

Thanks for the notice!

Posted by Henk van der Valk on 4 July 2010

Hi Brad,  

thanks for mentioning this new PAL beta;

I just upgraded my V1.36 PAL installation, and I must say the new V2 graphs do look great!  

To compare the two versions, I first ran an 2 day worth of perfmon file of a 32core/128GB RAM SQL2008 server through the old PAL V1.3.6, To analyze the 400 MN took 55 minutes.  With PAL V2.0, it takes almost double the time ; 1hour 50min. The powershell script burns a single core to 100%. Think it would be great if it was a bit more multithreading to reduce the overall processing time.

-> From an analysis point of view, the new beta did not find anything new ;-(  

Leave a Comment

Please register or log in to leave a comment.