UPDATE: AUGUST 26, 2014
Congratulations to Mike Lawell (@sqldiver) for winning the SQL Sentry Plan Explorer PRO license! Thanks to everyone who participated! We will be running more contests in the near future so check back here for more chances to win fun prizes.
What did Mike win?
Plan Explorer is a powerful query plan optimization tool that takes plan analysis to an entirely new level. It builds upon the graphical plan view in SQL Server Management Studio (SSMS) and allows you to quickly get to the root cause of tough SQL Server query optimization issues. Plan Explorer is available as a free version and a PRO version.
Features of the free version of Plan Explorer include:
- Color-coding that highlights potential trouble areas.
- Multiple grids and other views to allow for sorting and deeper analysis.
- Collection of real runtime metrics with the generation of actual plans.
- Upload plans to Answers.SQLPerformance.com to receive advice from industry experts.
Features of Plan Explorer PRO include all of the features in the free version, plus these and other features:
- Layout toolbar to allow you to easily manage bigger query plans.
- Multiple query tuning plans or sessions can be compared side-by-side.
- Different versions of your query can be kept within a single session.
- Contextual comments can be added to any version of your plan.