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:
The one addition that I make is to mark it as a system object.
BTW - This is my 100th blog.