SQL Server 2016 SP1 Bug with Graphical Execution Plans

Early adopters: if you’re rolling on SQL Server 2016 SP1, you may have noticed that when you click on query plans in sp_BlitzCache or sp_WhoIsActive, they sometimes render as ugly XML rather than the beautiful graphical showplan.

Here’s a 3-minute video showing the bug:

To work around it, save the XML plan as a file – but you’ll need to frame the name in double quotes, like “my beautiful query.sqlplan” and end it with a sqlplan extension. Then, open it up again, and SSMS renders it as a graphical plan.

To get this fixed, vote up these 3 Connect items:

Previous Post
Index Scans: Not Nearly As Bad As You Might Think
Next Post
[Video] Office Hours 2016/11/23 (With Transcriptions)

19 Comments. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.