Plan Explorer® – SQL Query Analysis
Find out why your queries are slow and fix them.
Key Features
- Spot the best index for any query and watch your performance improve in real time, before you even touch SQL Server.
- Detect data skew, parameter sniffing issues, and index tipping points immediately
- Pinpoint which operators are hitting your query hardest, without re-running the query
- See actual operator costs, not just SQL Server’s estimates, and toggle between the two instantly.
- Right-click any execution plan in SSMS and jump straight into Plan Explorer®
See what Plan Explorer can do
Features | ||
|---|---|---|
Query execution plan analysis
| ||
Index analysis with scoring | ||
Statistics analysis with histogram | ||
Actual plan recosting | ||
Superior plan diagram with color-coding | ||
SSMS add-in | ||
Live Query Replay | ||
Query performance profiling and playback | ||
Real-time performance monitoring and alerting | ||
Proactive advisory conditions | ||
Wait-time analysis | ||
Top SQL tracking and trending | ||
Deadlock analysis | ||
SQL Server Agent job monitoring | ||
Azure SQL and Amazon RDS support | ||
Cross-server performance dashboards | ||
Historical performance data and trending |
Plan Explorer is just the beginning
Plan Explorer® gives you deep SQL query analysis. Add SolarWinds SQL Sentry® and you get the full database performance monitoring platform around it.
- Plan Explorer® and SQL Sentry® are built for database professionals who need fast, accurate answers about SQL Server performance
- SQL Sentry® builds on Plan Explorer with real-time monitoring, proactive alerting, wait-time analysis, and query trending – across your entire data estate
- Get full visibility into blocking, deadlocks, top SQL activity, and SQL Server Agent jobs – all in one place
- Supports the Microsoft Data Platform, Azure SQL, and Amazon RDS
