How to determine what is running on a SQL Server

[David_Fergen]

Script to determine what is running on an SQL Server:

SELECT 

    p.spid, p.status, p.hostname, p.loginame, p.cpu, r.start_time, r.command, 

    p.program_name, text  

FROM 

    sys.dm_exec_requests AS r, 

    master.dbo.sysprocesses AS p  

    CROSS APPLY sys.dm_exec_sql_text(p.sql_handle) 

WHERE 

    p.status NOT IN ('sleeping', 'background')  

AND r.session_id = p.spid