Who is active?

A great script to add to your toolkit. sp_whoisactive by Adam Machanic.

It is a comprehensive activity monitoring stored procedure that works for all versions of SQL Server from 2005 through 2017.

Download it from:

http://whoisactive.com/

The one addition that I make is to mark it as a system object.

BTW - This is my 100th blog.

Recent Posts

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a...

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response...

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete...