Skip to content

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 creates the PAL reports.  To take advantage of this script you must use the SQLPSX (SQL Server PowerShell Extensions) available on CodePlex.  You will also need  the Performance Analysis of Logs (PAL) Tool and 7Zip installed.

For Part 1, visit this link.  You will need the table create in Part 1.

Part 3: Copy the Perfmon Log to the Central Server and Create PAL Report

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

Leave a Comment