Series: Automation of PAL

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

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 automtaing processes was Windows 2000 so I forgot about this tool.  Now I …

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

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

In 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 start the data collector or counter log on the remote servers for …

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

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

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 the each server to a central location.  After the copy is complete and loops back through each server and …

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