July 19, 2012 at 3:20 pm
why is it that when executing the following statement, the link in some rows will return graphical execution plan and in other rows they return the XML? I am just trying to figure out why the behavior is different between rows.
SELECT b.query_plan
FROM sys.dm_exec_cached_plans a
cross apply sys.dm_exec_query_plan(a.plan_handle) b
July 19, 2012 at 3:32 pm
could it be that really large execution plans are getting truncated at 8K in the grid,and since it's not valid XML with an ending tag, you only see the text version?
that's my first guess.
Lowell
July 19, 2012 at 5:31 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 19, 2012 at 6:05 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply