Features and Fixes in SentryOne Plan Explorer 19.1.2

Aaron Bertrand

Published On: September 6, 2019

Categories: SQL Sentry, Plan Explorer 0

Today we released SentryOne Plan Explorer 19.1.2. You can always download the new version directly.

The fixes included in 19.1.2 are as follows:

#57009 : Operator icon refresh

SwitchSwitchWe added a little more contrast to our icons - giving them better visibility on large screens or zoomed-out plans - and swapped a few out for more intuitive graphics (I am particularly fond of the new visualization for Switch). I showed the set of icon changes, which included correcting the icons for key and RID lookups, in a recent post about the Plan Explorer extension for Azure Data Studio.

#41513 : Switch Start Page to use Chromium

The initial implementation of the start page inside Plan Explorer used a control based on Internet Explorer. This wasn't really a problem, except that to get HTML/CSS to play nice there and also in Chrome was rather tedious. In addition, the IE control forced Internet Explorer to be the handler for all links. Given Microsoft's shift away from Internet Explorer and their increasing development on a Chromium-based version of Edge, it was time to switch out.

#52166 : Missing Index script generated with incorrect syntax

In a few isolated situations, missing index recommendation scripts were being generated with an additional trailing comma in the column list. We've identified these edge cases and resolved the issue.

#49189 : Exception occurs when no plan is associated with a statement

In certain scenarios, when matching statements with trace rows, there would be a "miss" - meaning we were unable to match a statement directly. If you clicked on a row in the statement grid when such a miss happened, an exception was raised. We've done two things as a result: we've bolstered our statement matching logic, and we also now handle the exception more gracefully.

Aaron (@AaronBertrand) is a Data Platform MVP 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. 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.