November 18, 2016 at 7:46 am
Hi all,
it seems that ever since we upgraded to SP2 CU1 we can no longer open XML link to graphical query plan 🙁
SELECT top 100 [qp].[query_plan]
FROM sys.dm_exec_cached_plans cp
CROSS APPLY sys.dm_exec_sql_text (cp.plan_handle) st
CROSS APPLY sys.dm_exec_query_plan (cp.plan_handle) qp
If I click on the output and this shows the showplan xml. How do I view the graphical plan from this?
Thanks in advance!
It's exactly the same problem as here:
http://www.sqlservercentral.com/Forums/Topic1220343-1550-1.aspx
November 21, 2016 at 11:56 am
Ok, so maybe no one knows how to fix this so how about:
Can anyone confirm they have a SQL 2014 SP2 instance where the graphical query plan viewer still works?
November 21, 2016 at 12:29 pm
I've figured this out... Same deal as here: http://sqlblog.com/blogs/aaron_bertrand/archive/2011/10/28/getting-graphical-showplan-back-in-sql-server-2008-r2.aspx
Our issue was that it was remote clients that this stopped working on, so I simply went a server we had with the full install - stole it's file and replaced it on the remote clients. Bob's now our uncle!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply