Diagnose
Find which queries are costing you the most, get a full report on one of them, and check the overall health of the database.
Three screens cover diagnosis, and they are listed here in the order you would normally reach for them.
Slow Queries
Rank every query by how much database time it consumes. Start here when you know something is slow but not what.
Analyze Query
Everything about one query: execution plan, cost, index recommendations, and rewrites. Start here when you already know which query.
Health Check
A full report on the database itself: configuration, sizing, indexes, and workload. Start here when you have inherited a database.
Choosing between them
| What you know | Where to go |
|---|---|
| "The app is slow and I do not know why" | Slow Queries, then Analyze the worst offender |
| "This one query is slow" | Analyze Query |
| "I just took over this database" | Health Check |
| "We are about to ship a schema change" | Analyze Query against the new query |
| "I need something to hand to a colleague" | Health Check, then export the report |
The three connect to each other. Slow Queries has an Analyze button on every row, which carries the query straight into Analyze Query. A health check surfaces its own list of expensive queries, each of which can be analyzed the same way.