Search

Valid showplan XML fails to automatically produce graphical showplan by Adam Machanic

Closed
as By Design Help for as By Design

26
0
Sign in
 to vote
Type: Bug
ID: 652855
Opened: 3/22/2011 10:23:39 AM
Access Restriction: Public
2
Workaround(s)
8
User(s) can reproduce this bug
In most cases, when clicking on showplan XML returned by a DMV, the graphical showplan automatically pops up. However, I have found one case (the attached file) where this fails. If the XML is saved as a .SQLPLAN file it works, but not when clicking from the results grid.
Details (expand)
Product Language
English

Version

SQL Server 2008 R2 - Developer Edition

Category

Tools (SSMS, Agent, Profiler, Migration, etc.)

Operating System

Windows 7 Professional (SP1)
Operating System Language
US English
Steps to Reproduce
Run the attached script in SSMS in Results to Grid mode. Click on the XML value that is returned.
Actual Results
The XML will be displayed in a new tab, as XML. After saving the XML to a .SQLPLAN file it can be viewed as a graphical showplan.
Expected Results
The XML should be automatically disaplayed as a graphical showplan without saving to a .SQLPLAN file.

Platform

32
File Attachments
File Name Submitted By Submitted On File Size  
showplan_wont_show.sql Adam Machanic 3/22/2011 341 KB
showplan_wont_show.sql Adam Machanic 3/22/2011 341 KB
Sign in to post a comment.
Posted by aaronbertrand on 10/27/2011 at 1:12 PM
Why does the Microsoft response make it sound like this is a feature request? This is a REGRESSION in behavior and should be treated as such. "...we are going to implement this requested behavior" should read "...we are going to fix this behavior that we broke"
Posted by Chandan jha on 9/29/2011 at 7:07 AM
I am having the same issue since I applied SP1 to 2008R2 version. I try to retrieve execution plans in the cache and none of them show GUI, all they show is raw XML. Saving it as splplan and then opening it is a pain. As a DBA, execution plan is my bread and butter so need this fixed in coming CU. I hope it happens soon.
Posted by Microsoft on 5/21/2011 at 3:39 AM
Dear Adam,

Thank you for reporting the connect item 652855: valid plan XML fails to automatically produce a graphical plan. I am happy to let you know we are going to implement this requested behavior as part of a ShowPlan improvement project. This issue will now be closed. For tracking purpose kindly quote vsts id: 734156. Please do let us know if you habe any other suggestions/ feedback on the ShowPlan feature.

regards

Seshagiri
PM, SSMS
Sign in to post a workaround.
Posted by EduQuint on 11/6/2011 at 4:24 AM
Copy the showplanxml.xsd file from the Denali version.

Apparently this will work.

See Aaron Bertrand blog on sqlblog.com.
Posted by aaronbertrand on 1/8/2012 at 6:14 PM
Here is the blog post EduQuint is referencing:

http://sqlblog.com/blogs/aaron_bertrand/archive/2011/10/28/getting-graphical-showplan-back-in-sql-server-2008-r2.aspx
© 2012 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement