Andrew Kelly announces a new version of an old tool:
I initially created the first version of this utility many years ago as an alternative to the immensely popular tool developed by Adam Machanic called sp_WhoIsActive. I wanted something that would suit most of my everyday needs for a snapshot type of view of the current activity on a SQL Server instance.
I know what you are thinking: why couldn’t I just use sp_WhoIsActive?
Well, I have used it for many years and in some cases still do when a special need arises. The main motivator for creating sp_CheckActivity was not for lack of features but…it’s more like there can be too many.
Click through for more information about sp_CheckActivity and grab a copy from the GitHub repo if you’re so inclined.