October 25, 2011 | SQL Server

SQL Sentry Plan Explorer v1.3

On Friday, we published a new version of our free query plan analysis tool, SQL Sentry Plan Explorer. As noted in the change list, we've added a couple of important features.

SQL Server 2012 support

With a whole slew of changes to the showplan schema in Denali, we've added operators and columns to reflect these changes. For example, you will notice the new Window Spool operator:

 

As well as the ColumnStore index scan operator, and details about the new batch execution mode:

And while we don't add all new columns by default, you can also optionally show data for new items such as the FORCESCAN hint (also added in SQL Server 2008 R2 SP1).
 

Table-level I/O metrics

When you generate an Actual Plan from Plan Explorer, we collect additional runtime metrics you won't get from Management Studio's showplan – duration, CPU, and I/O. While it is easy to show the total reads for a query, it is not always easy or intuitive to decipher which object(s) those reads came from. We've added a Table I/O tab that breaks it down by object, making it very easy to see where the majority of your I/O is coming from:

Note that this and other runtime information is not available with an estimated plan of any kind, or with an actual plan generated by Management Studio – the information simply isn't there. We can only show runtime metrics when you generate an actual plan within Plan Explorer (or if you've captured plans using SQL Sentry Performance Advisor).

We hope you find these enhancements useful and, as always, please let us know if you have any issues or questions.

As a side note, the SSMS add-in hasn't changed.
 

9 comments on this post

    • Uri Dimant - October 26, 2011, 9:34 AM

      Hi Aaron
      Do plan to add Table IO tab when I click   SQL Sentry Plan Explorer from SSMS? Also after an installation with enabled option (check for updates) I am getting error "There was a problem retrieving latest build number, One or more errors occurred" My build is 6.4.921.0
      I unchecked this option and error disappeared :-))

    • Uri Dimant - October 26, 2011, 9:34 AM

      Hi Aaron
      Do plan to add Table IO tab when I click   SQL Sentry Plan Explorer from SSMS? Also after an installation with enabled option (check for updates) I am getting error "There was a problem retrieving latest build number, One or more errors occurred" My build is 6.4.921.0
      I unchecked this option and error disappeared :-))

    • AaronBertrand - October 26, 2011, 6:24 PM

      Uri,
      We can't provide runtime metrics if we didn't generate the plan. The information we use to derive that data is obtained outside the scope of SET SHOWPLAN, and isn't included in the Management Studio version of the plan (it only includes estimated CPU etc. even for actual plans – you can see this in the XML). Therefore as described above the only way to get these numbers is to generate an actual plan within Plan Explorer.
      The error sounds like a proxy/firewall issue, and I think your network admin or equivalent would be far better equipped to help with that issue than I would. What happens when you try to connect to the following URL in a web browser? https://licensing.intercerve.com/VersionCheck.asmx?wsdlAlso still curious why every time you post a comment we get two…

    • Uri Dimant - October 26, 2011, 7:04 PM

      Hi Aaron
      1) I see
      2) Click on the link I got "This XML file does not appear to have any style information associated with it. The document tree is shown below"
      3) I do not know, I changed all web browsers same things on I7/8/9, Chrome,Firefox

    • AaronBertrand - October 26, 2011, 7:15 PM

      Uri,
      2) So you can get to the file (to be clear, that's not an error, just info). Are you using any connectivity software or proxy server? This can be anything from ZoneAlarm to the built-in Windows firewall. I'm wondering if somehow your web requests are doing a double-tap of some sort (I would blame Community Server but you seem to be the only person with this experience on this site, and 2) and 3) may be related).
      Curious if you can disable any and all security/firewall/connectivity software and/or try from a different machine or network. The file is there and you've proven you can reach it, so something is not letting the program do the same thing the browser is doing.

    • Uri Dimant - October 27, 2011, 10:15 AM

      Aaron
      We use a proxy server. Within a company firewall is off, will be working on with our network admin.. BTW, by using I8 I got three copies of my post (public forums) but replace it to Chrome I am getting only two copies , is there a progress :-)))))
      Thanks, great tool, using it all the time.

    • Uri Dimant - October 27, 2011, 10:15 AM

      Aaron
      We use a proxy server. Within a company firewall is off, will be working on with our network admin.. BTW, by using I8 I got three copies of my post (public forums) but replace it to Chrome I am getting only two copies , is there a progress :-)))))
      Thanks, great tool, using it all the time.

    • LukeC - November 1, 2011, 7:53 PM

      Very nice addition!  Do the IO results match up with what can be seen when setting statistics IO on?  If so I've been looking for a way to get those results into a cleaner format and this may be the answer.  Thanks

    • AaronBertrand - November 1, 2011, 8:04 PM

      Thanks Luke, yes, same data as you see in Statistics I/O output. Just formatted nicer. šŸ™‚

Comments are closed.