SQL Server System Monitor as a Script

Here is a cool script that shows SQL server system information just like in System Monitor.
Copy and paste the script below, it's very small, or download script here: https://docs.google.com/file/d/0B07PMQYOhF2DZDJQQ1BiTmIyaTA/edit?usp=sharing


-- Process Moniitor Script
SELECT spid
,blocked
,DB_NAME(sp.dbid) as DBName
,program_name
,waitresource
,lastwaittype
,sp.loginame
,sp.hostname
,a.[Text] as [TextData]
,SUBSTRING(A.text, sp.stmt_start / 2,
 (CASE
WHEN sp.stmt_end = -1
 THEN DATALENGTH(A.text)
 ELSE sp.stmt_end
 END - sp.stmt_start
 )/2) AS [current_cmd]
FROM sys.sysprocesses sp
OUTER APPLY sys.dm_exec_sql_text (sp.sql_handle) as A
WHERE
spid > 50
ORDER BY
blocked DESC
,DB_NAME(sp.dbid) ASC
,a.[text]