Background:
The purpose of this article is to
provide a simple way of getting a list of all the concurrently running queries
on the SQL Server using T-SQL script.
The purpose of this article is to
provide a simple way of getting a list of all the concurrently running queries
on the SQL Server using T-SQL script.
T-SQL Script:
|
SELECT
DMST.[TEXT] AS SQLQuery,
DMR.SESSION_ID AS SessionID,
DMR.[STATUS] AS [Status] ,
DMR.COMMAND,
DMR.CPU_TIME,
DMR.TOTAL_ELAPSED_TIME
FROM SYS.DM_EXEC_REQUESTS
DMR
CROSS APPLY SYS.DM_EXEC_SQL_TEXT(SQL_HANDLE) AS DMST
WHERE DMR.SESSION_ID
<> @@SPID |
Unite Testing:
Run some of the long running queries
on management studio in various window and execute this script. This script
will provide you the list of all the running queries on SQL Server along with
time taken by query.
Run some of the long running queries
on management studio in various window and execute this script. This script
will provide you the list of all the running queries on SQL Server along with
time taken by query.
Query O/P:
