SentryOne Plan Explorer

SentryOne Plan Explorer is a standalone Windows application that can be used to overcome database performance barriers using its query tuning features.

It accomplishes this by using many plan analysis features, without requiring equire a collector service or database.

Choosing the best Indexes worth supporting is made easy with the help of this program's scoring algorithms. Once determined, these indexes can be reviewed, created, edited, and have their old statistics detected and then updated.

Each modification is followed by a real-time change in the actual efficiency score, allowing you to customize everything to get as close to 100% efficiency as possible. This score preview allows you to see whether a solution is efficient or not before you even make any change in the SQL Server's line of code.

Along with the actual scoring, you also benefit from an in-depth detection system that gives you detailed information about potential issues that may arise, such as the impact of compiled and runtime query parameters on performance, or parameter sniffing issues.

The program also acts as a money-saver, since it allows you to toggle between "Actual" and "Estimated" cost, which showcase the actual observed costs.

Toggling between the two makes it easier to spot potential differences.