Skip to content

Instantly share code, notes, and snippets.

@hakanak

hakanak/MonitoringScripts.sql

Created December 29, 2019 18:26
Show Gist options
  • Save hakanak/3c23240a0eb8c066f75936282be8bfb3 to your computer and use it in GitHub Desktop.
Save hakanak/3c23240a0eb8c066f75936282be8bfb3 to your computer and use it in GitHub Desktop.
Download ZIP
Monitoring Scripts
Raw
MonitoringScripts.sql
select text,
SUBSTRING(st.text, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(st.text)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2) + 1) AS statement_text,
* from sys.dm_exec_requests qs
cross apply sys.dm_exec_sql_text(sql_handle) st
cross apply sys.dm_exec_query_plan(plan_handle);
@hakanak
Copy link
Author

hakanak commented Dec 29, 2019

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment