Tag Archives: TSQL

Monitoring CPU

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

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