SQL Server monitoring rogue processes
Run one of these queries to check if there are any SPIDs with Blocked Status or High CPU time. It also shows the hostname, loginname, logintime info.
Run this command to get the SQL for a SPID
DBCC INPUTBUFFER (<SPID>)
Run this command to get more info about the lock