jump to navigation

PAL (Performance Analysis Log Tool) December 4, 2008

Posted by msrviking in Performance tuning.

Sometime last week I was approached by one of my peers asking for help in analyzing the Windows performance counters of a SQL Server system and share my thoughts.

Although I was given a day time to get back, but at the back of my mind I was wanting to do two things. I should share well analyzed and conclusive thoughts, but quickly. How do I do it? For some reason I don’t remember how I got to this link – PAL but it turned out to be real worth to use it. It took me just half-hour to conclude what is right and wrong in the system based on the reports that is generated from this tool. And I got back with results quickly, of course the correct ones though :).

You could visit the link and see it for yourself what you need to do. Thanks to PSS engineers who have spent time to build this tool and sharing it among the community. Great job, people! Here is a quick peep into what it is all about,

“Ever have a performance problem, but don’t know what performance counters to collect or how to analyze them? The PAL (Performance Analysis of Logs) tool is a new and powerful tool that reads in a performance monitor counter log (any known format) and analyzes it using complex, but known thresholds (provided). The tool generates an HTML based report which graphically charts important performance counters and throws alerts when thresholds are exceeded. The thresholds are originally based on thresholds defined by the Microsoft product teams and members of Microsoft support, but continue to be expanded by this ongoing project. This tool is not a replacement of traditional performance analysis, but it automates the analysis of performance counter logs enough to save you time. This is a VBScript and requires Microsoft LogParser (free download).”




No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: