Skip to content

Instantly share code, notes, and snippets.

@smarenich
Created October 19, 2015 04:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save smarenich/3026569420463ca2a51c to your computer and use it in GitHub Desktop.
Save smarenich/3026569420463ca2a51c to your computer and use it in GitHub Desktop.
SELECT
db_name(s2.dbid),
( SELECT TOP 1 SUBSTRING(s2.text, r.statement_start_offset / 2,
( (CASE WHEN r.statement_end_offset = -1 THEN (LEN(CONVERT(nvarchar(max),s2.text)) * 2)
ELSE r.statement_end_offset END) - r.statement_start_offset) / 2) ) AS sql_statement,
r.logical_reads
FROM
sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2
WHERE
s2.objectid is NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment