Tag Archives: TSQL

Monitoring CPU

Posted on October 21, 2019 by

As part of a licensing project, it was found to be very useful to get an overview of current servers CPU across the SQL estate. There was an expensive 3rd party software solution that was reporting high CPU usage on … Continue reading →

Posted in Management Studio, Performance Tuning | Tagged , , , , | Leave a comment

Using Output

Posted on May 4, 2014 by

The OUTPUT command can be a very useful tool to use at times. The following scripts show a couple of ways it can be used. The code from these scripts can be found here on my shared dropbox. First off … Continue reading →

Posted in Tips & Tricks, TSQL | Tagged , | Leave a comment