Advertisement
Guest User

Get queryplan for a function

a guest
Nov 28th, 2013
1,244
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.58 KB | None | 0 0
  1. SELECT
  2.   PlanCreated       = qs.creation_time,
  3.   ObjectName        = object_name(st.objectid),
  4.   QueryPlan         = CAST(qp.query_plan AS xml),
  5.   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))
  6. FROM sys.dm_exec_query_stats AS qs
  7.   CROSS apply sys.dm_exec_sql_text(qs.sql_handle) AS st
  8.   CROSS apply sys.dm_exec_text_query_plan(qs.plan_handle, qs.statement_start_offset, qs.statement_end_offset) AS qp
  9. WHERE object_name(st.objectid) = 'FunctionName'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement