https://community.qlik.com/t5/Official-Support-Articles/How-to-determine-what-is-running-on-a-SQL-Server/ta-p/1740783 <P>Script to determine what is running on an SQL Server:</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">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 </LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 05 Feb 2021 22:00:36 GMT David_Fergen 2021-02-05T22:00:36Z https://community.qlik.com/t5/Official-Support-Articles/How-to-determine-what-is-running-on-a-SQL-Server/ta-p/1740783 <P>Script to determine what is running on an SQL Server:</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">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 </LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 05 Feb 2021 22:00:36 GMT https://community.qlik.com/t5/Official-Support-Articles/How-to-determine-what-is-running-on-a-SQL-Server/ta-p/1740783 David_Fergen 2021-02-05T22:00:36Z