Shows just the active processes from vwWho3.
IF object_id('dbo.vwWho3') Is Not Null
DROP VIEW vwWho3
CREATE VIEW [dbo].[vwWho3]
/* DATE AUTHOR REMARKS
8/1/11 PPaiva Initial creation.
Same as vwWho2 except this only gets active processes, plus
one row from spids between 1 and 50, so that it is easy
to show the date/time this instance of SQL Server was
If spid = -2, it is an orphaned distributed transaction.
This can be terminated with
KILL 'Unit Of Work ID (this is a guid)'
WHERE Status Not In ('sleeping')
OR Blocked <> 0
OR Open_Tran <> 0
OR spid < 1