get_wait_stats
Identify database bottlenecks by retrieving top wait statistics from sys.dm_db_wait_stats, with category mapping and root-cause recommendations.
Instructions
Get top wait statistics from sys.dm_db_wait_stats with category mapping (CPU, I/O, Lock, Memory, Network, etc.), benign wait filtering, and root-cause recommendations.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top_n | No | Number of top waits to return. | |
| database_name | No | Optional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||