Sign up to our newsletter...

...and be the first to learn about new releases

SQL CoPilot Version 1.6
An execution plan summary, and compatibility with SQL Server 2014

By Richard Fryar

Version 1.6 of SQL CoPilot has just been released.

This release is the first to be compatible with SQL Server 2014.

After extensive testing I am pleased to announce the first version of SQL CoPilot that can be used with SQL Server 2014 - one of the first tools on the market to do so.

As well as that, we have added what I think is one of the most useful reports yet - the Execution Plan Summary.

When you look at an execution plan, what do you want to see?

What you often see, especially for a complex set of queries, is a mass of graphical symbols. For in-depth analysis this is of course very useful, but it can take some studying to get to the core of the problem.

What you usually want to know is:

  • Which statement(s) in a multi-statement plan are the most costly
  • Which tables are responsible for the most estimated I/O, and is this due to scans or seeks
  • Is parallelism being used
  • Has the database engine identified any missing indexes
  • Are there any warnings, such as for no join predicate or missing column statistics

That is exactly what you get in this new report.

Any existing report where a plan handle is available now has buttons that take you directly to the Execution Plan Summary.

These are:

  • Session Details - which itself is accessible from multiple reports
  • Activity | Historical | Highest CPU
  • Activity | Historical | Longest Duration
  • Activity | Historical | Most Reads
  • Activity | Historical | Most Writes
  • Activity | Snapshots | Active Queries
  • Database | Plan Analysis

Here are some examples of what the report looks like.