• Adam Thurgar

Whoisactive - logging table and schedule


I have blogged previously about what a great tool sp_whoisactive is from Adam Machanic. Sometimes you may need it to be run regularly to capture what is happening, instead of hoping if you run it interactively and you get the results you want. There is a script from Brent Ozar (and a few others) that will allow you to get the information from sp_whoisactive into a logging table. It also purges the table to make sure it doesn't get too large. You can then create a SQL Server Agent job that runs this script and then schedule it as required. Then you will need to query the logging table to hopefully find the issue. Just another way to be proactive in finding what is happening on your SQL Server.


3 views

Recent Posts

See All

Cardinality estimator

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 compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

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 from. They also knew that deleting large amounts of data causes t