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 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
Tracy Boggiano
Follow me

Tracy Boggiano

Database Administrator at ChannelAdvisor
Tracy has spent over 20 years in IT and has been using SQL Server since 1999 and is currently certified as a MCSE Data Management and Analytics. She has worked on SQL Server 6.5 and up including currently SQL 2017 CTP 2.0. She enjoys monitoring, performance tuning, and high availability and disaster recovery technologies. Tracy is currently a co-organizar the for special interest group for Advanced DBA Topics for the TriPASS user group.

She also tinkered with databases in middle school to keep her sports card collection organized.

Tracy has volunteered through the NC Guardian ad Litem program since 2003 advocating for abused and neglected foster children in court.This is her passion outside of SQL Server and favorite job.More information about this program in North Carolina can be found at http://volunteerforgal.org or the national organization CASA at http://www.casaforchildren.org.
Tracy Boggiano
Follow me