Tracy Boggiano's SQL Server  Blog Rotating Header Image

Automation

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

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 […]

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

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 […]

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

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 […]