Tag Archives: TSQL

Azure Data Studio – Database Status Dashboard (5/31)

Posted on March 5, 2020 by

One of the things I was finding I was missing was when restoring databases and adding into availability groups. It was quite easy to see in SSMS when databases, were synchronized or syncronizing or had just plain, fell over when … Continue reading →

Posted in Azure Data Studio, Dashboards, SQLSaturday, Tips & Tricks, TSQL | Tagged , , , | Leave a comment

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