Plan Explorer is a single installation file containing the application and the SQL Server Management Studio (SSMS) add-in, which allows you to jump directly to Plan Explorer from SSMS.
“With over 250,000 downloads of Plan Explorer to date, it has become the tool of choice for SQL Server query optimization.”
You can write different SQL queries to attain the same results, but do you want to run a query that will slow server performance? Of course not. Every DBA will encounter poor performing queries or performance issues that seem to be inexplicable. The best way to explain these issues is to dive into the execution plan. You want to use the best query possible to improve performance not slow it down. SQL query optimization is an important part of SQL Server administration, and you need to tune your queries based on what you are trying to achieve to get the best results.
While SQL Server Management Studio does include the built-in functionality to review execution plans, it isn’t always the most useful. SentryOne Plan Explorer was designed to make SQL query optimization easier than native SSMS tools. Plan Explorer is a lightweight, standalone tool that does not require a collector service or database.
This standalone Windows application contains many of the plan analysis features included in the full SentryOne Platform software but does not require a collector service or database.