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 today.  To take advantage of this script you must use the SQLPSX (SQL Server PowerShell Extensions) available on CodePlex.  On my system I run this every night at midnight to start a new file for analysis.

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

Part 2:  Stop the Performance Monitor Data Collector or Counter Log Each Night

Part 3 will be the process that creates all the reports and zips up the performance counter file on a central server.

Series Navigation<< Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 1Automation of PAL (Performance Analysis of Logs) Tool for SQL Server Using Powershell – Part 3 >>
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 Platform. She has worked on SQL Server 6.5 and up including currently SQL 2017 CTP 2.0. She enjoys monitoring, performance tuning, and disaster recovery technologies.

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

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through http://www.casaforchildren.org.
Tracy Boggiano
Follow me