Monday, June 15, 2009

My Favorite SQL Server Log Analysis Tool has been updated

Performance Analysis of Logs for (#SQL Server 2000/05, #IIS, #Exchange, #MOSS, #Active Directory) has been upgraded! Latest build is as of June 12, 2009, version 1.3.5. I have used version 1.3.4.3 prior to this but I'm about to install this latest version and take it for a spin. Can't wait to see what's new in this release. With PAL for SQL Server, you need to generate a .BLG file with pssdiag for SQL 2000 or SQLDIAG for 2005 and then use it as input for PAL. It will run a VBscript and generate an HTML report that you can submit to your manager for review. It shows all the important performance stats for SQL, disk performance and memory. I use it to find my performance hogs. No major changes seen so far. Get yours at Codeplex.

Aslo good for log analysis of IIS, Exchange, BizTalk and other Microsoft Technologies. Requires .NET 2.0.

Enjoy.
Post a Comment