I recently was re-exposed to the PAL (Performance Analysis of Logs) Tool available on CodePlex at a wonderful SQLskills class. I had played with the tool in the past, but at the time the server I had for setting things up and automating processes was Windows 2000, so I forgot
In this part of the process, we will set up a process to automatically stop the data collector or counter log on the remote server. Then rename the file with a time stamp if it is an older version of Windows. Finally, we will start the data collector or counter
In the final part of the process will be the process that creates all the reports and zips up the performance counter file on a central server. The first part copies the PerfMon file from each server to a central location. After the copy is complete and loops back