Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Four free SQL Server tools every DBA can use

3/5

SQL Sentry Plan Explorer

Source:  sorbetto/iStock
Visual Editor: Sarah Evans

When digging into why a given query might be running slowly, one of the first places to look is that query's execution plan. SQL Server's built-in graphical execution plans show the data retrieval methods chosen by the SQL Server query optimizer, but making sense of those plans can be daunting.

SQL Sentry Plan Explorer goes beyond the basic functionality provided by SQL Server and makes it easier to see where issues exist in an execution plan. The free version of SQL Sentry Plan Explorer provides multiple views of execution plans, which can make them easier to analyze. It also uses color coding to highlight potential problem areas like table scans, key lookups, cumulative operation costs and parallelism so they're easier to find, and zoom controls make it possible to see more of an execution plan on your screen. In addition, you can collect runtime metrics when you generate plans.

SQL Sentry Plan Explorer is also available in a commercial version that adds the ability to open multiple query tuning sessions at the same time and other features.

View All Photo Stories

Join the conversation

1 comment

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

How would you rate SQL Sentry Plan Explorer?
Cancel

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close