Performance Analysis of Logs (PAL) Tool Project Description 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...
Many customers asked me pretty much the same question: “I want to monitor the SQL Server 2005 using Performance Monitor. What are the most relevant counters?” To answer this question I attached my list of counters. This is not an official list from Microsoft, just my recommended list. Feel free to comment about my suggested list. Relevant Links: PSSDiag – configure pre-defined sets of Performance Monitor counters http://www.microsoft.com/downloads/details.aspx?familyid=5564386A-28C2-4483-8293-76FFF67B9EB3&displaylang...