get_query_store_stats
Retrieve top resource-consuming queries from SQL Server Query Store to identify performance bottlenecks. Sort by CPU, duration, reads, writes, or executions and limit results.
Instructions
Get top resource-consuming queries from Query Store (SQL Server 2016+). Query Store must be enabled on the database.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Database name (uses connection default if omitted) | |
| sort_by | No | Sort metric (default: cpu) | |
| top | No | Number of top queries (default: 10) | |
| server | No | Target server name (uses default if omitted) |