A few quick fixes for Plan Explorer
SSMS v17 Add-In
We've received a lot of questions about supporting the latest version of Management Studio, which has been completely decoupled from the database engine. This new version is now supported by the Plan Explorer add-in; however, you'll have to restart SSMS after updating Plan Explorer in order to see the change.
Initially, we put the query text onto the operator tooltip, but this could cause problems for longer queries - pushing things like sort and spill warnings off the tooltip. We've removed the query here to avoid this issue and also because it's redundant - it's in the Statement grid, the Text Data pane, and usually on the Command Text tab as well.
SQL Server 2017 DOM support
Previously, if you tried to run multiple batches against a SQL Server 2017 instance, you might have seen a syntax error parsing the keyword
GO. This was because of a mismatch in the DOM version between Plan Explorer and the database engine, and has now been resolved. We still have some work to do in order to support plans that contain new operators, like Adaptive Join, and some other version-specific showplan additions.
We've started thinking about some new functionality on the toolbar, and the first step was making some room. The
Anonymize button has been removed, partly because it's in a menu as well, and partly because most of the people who have used this option didn't really need to anonymize anything.
Aaron (@AaronBertrand) is a Product Manager at SentryOne, with industry experience dating back to Classic ASP and SQL Server 6.5. He is editor-in-chief of the performance-related blog, SQLPerformance.com, and serves as a community moderator for the Database Administrators Stack Exchange. Aaron's blog focuses on T-SQL bad habits and best practices, as well as coverage of updates and new features in Plan Explorer, SentryOne, and SQL Server.