Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 1

This entry is part 1 of 3 in the series Automation of PAL

This entry is part 1 of 3 in the series Automation of PALI 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 automtaing […]

Read More »

Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 2

This entry is part 2 of 3 in the series Automation of PAL

This entry is part 2 of 3 in the series Automation of PALIn this part of the process we will setup 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 […]

Read More »

Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 3

This entry is part 3 of 3 in the series Automation of PAL

This entry is part 3 of 3 in the series Automation of PALIn 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 the each server to a central location.  […]

Read More »