Query Analysis turns historical query execution into a dollar figure and a fix. It's where WISdom identifies which SQL Statements are actually driving cost and inefficiency across your SQL Server environment, then hands you a path to act on it, whether that's an index change, a query rewrite, or a defensible ROI case for the work.
It's also the place to see usage patterns across your environment, or across whatever set of instances and databases you filter to. Sort by CPU or IO to quickly surface the poorest-performing queries in scope, not just the most expensive ones by spend.
Unlike Activity, which is built for troubleshooting what's happening right now, Query Analysis takes the long view. It's meant for looking across weeks or months of workload history to find the recurring, expensive patterns that are worth the effort to fix, and for putting a cost on them your team can act on.
This section is organized into four pages:
- Overview – the starting point. Summarizes cost and efficiency across the full workload in scope, shows how concentrated that cost is across your code, and surfaces the Query Impact Analysis table to sort by Spend, CPU, or IO and find the queries worth acting on.
- Details – the drill-down. Opens once a SQL Statement is selected from Overview, breaks its cost down by instance and database, and opens the Query Analysis flyout with the full picture for a specific query, including performance history, properties, and FinOps projections.
- Optimizations – how WISdom's automated and on-demand query optimization engine works: how candidates are selected, how optimization credits are consumed, and how to read the recommendations and scripts it produces.
- Query Optimization FAQ – answers to common questions about optimizations, including credit use and why a query may be Un-optimizable.