Year: 2012

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”

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 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”

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

This month’s T-SQL Tuesday is brought to us by Argenis Fernandez (blog | @DBArgenis). Argenis is asking if we specialize or not, why we do (or don’t) specialize, and why we feel that’s a good thing. I started out my career as a Jack of All Trades mainly because my first employer was a small …

Read More “T-SQL Tuesday #028 – Jack of All Trades, Master of None?”

A New Year Means New Resolutions – 2012

I usually do not make resolutions because that seems like you are trying to give up something instead of gaining something.  I would prefer to call them goals that way they can be a list of possible accomplishments instead of potential failures.  For 2012, I decided to record my goals for the New Year and …

Read More “A New Year Means New Resolutions – 2012”