Plan Explorer – a free SQL query analysis and optimization tool
Plan Explorer by SentryOne is a free SQL query analysis and optimization tool that helps you quickly get to the root of the toughest SQL Server query problems. With Plan Explorer, break through database performance barriers with advanced query tuning features not found in any other tool.
This standalone Windows application contains many of the plan analysis features included in the full SentryOne software, but does not require a collector service or database.
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.
Plan Explorer’s scoring algorithms help you determine the best index to support a given query. Easily view recommended indexes, create and modify indexes, and detect and update old statistics. Watch the score change in real time as you work toward the elusive 100% score—before executing a single line of code against SQL Server.
With Plan Explorer one can easily investigate the processes and queries involved in a deadlock with instant access to all of the information you need—and none that you don’t. Plan Explorer displays the sequence of operations on the diagram, with the full query text and call stack in the treeview.
[button-green url=”https://downloads.sentryone.com/downloads/sqlsentryplanexplorer/x64/PlanExplorerInstaller.exe” target=”” position=”left”]Download Plan Explorer[/button-green]