A bLoG by ♚ Suresh babu ♚
Search This Blog
Wednesday, April 18, 2012
SQL DBA - TSQL to find all TSQL/Commands running on a server at a time?
SELECT
sqltext
.
TEXT
,
req
.
session_id
,
req
.
status
,
req
.
command
,
req
.
cpu_time
,
req
.
total_elapsed_time
FROM
sys.dm_exec_requests
req
CROSS
APPLY
sys.dm_exec_sql_text
(
sql_handle
)
AS
sqltext
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment