Plan Explorer – SQL Query Analysis Quickly get to the root of query problems with a free query analysis tool

Key Features
  • Index Analysis
  • Statistics Analysis With Histogram
  • Actual Plan Recosting
  • Superior Plan Diagram
  • SSMS Add-In

Index analysis

Index analysis

The SQL Sentry® Plan Explorer® free query analyzer includes scoring algorithms to help you determine the best index to support a given query. You can 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.

Statistics analysis with histogram

Statistics analysis with histogram

Clearly see the impact of compiled and runtime query parameters on performance, quickly spot data skew capable of contributing to parameter sniffing issues, visualize the index Tipping Point, and identify opportunities for better indexes.

Plan diagram

Plan diagram

Quickly identify the most costly operators through intuitive color-coding and various display options, including the ability to view operator costs by I/O or CPU.

Query performance profiling and playback

Query performance profiling and playback

Replay queries with access to their live performance statistics through integrated history charts. With the Plan Explorer free query analyzer, you can play back the query profile to see exactly which operators are adding the most load on system resources without having to run the query again.

Actual plan recosting

Actual plan recosting

Instead of delivering only an estimated (and often inaccurate) cost for a plan operator, Plan Explorer can display the actual observed costs. You can see the difference by toggling the view between Estimated and Actual cost.
Ready to end your database performance problems?

Try SolarWinds®

SolarWinds SQL Sentry

Database performance monitoring for the Microsoft Data Platform with fast root cause analysis and visibility across the data estate

  • Fast root cause analysis

  • Visibility across the data estate

  • Deep, actionable performance metrics with easy deep-dive capabilities

  • Proactive alerting and response system

Full Featured Product

Try It Out for 14 Days

Fully functional free trial

DOWNLOAD FREE TRIAL EMAIL LINK TO TRIAL
Learn More
Close
{{STATIC CONTENT}}
{{CAPTION_TITLE}}

{{CAPTION_CONTENT}}

{{TITLE}}