Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- PlanCreated = qs.creation_time,
- ObjectName = object_name(st.objectid),
- QueryPlan = CAST(qp.query_plan AS xml),
- QueryText = SUBSTRING(st.text, 1 + (qs.statement_start_offset / 2), 1 + ((isnull(NULLIF(qs.statement_end_offset, -1), datalength(st.text)) - qs.statement_start_offset) / 2))
- FROM sys.dm_exec_query_stats AS qs
- CROSS apply sys.dm_exec_sql_text(qs.sql_handle) AS st
- CROSS apply sys.dm_exec_text_query_plan(qs.plan_handle, qs.statement_start_offset, qs.statement_end_offset) AS qp
- WHERE object_name(st.objectid) = 'FunctionName'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement