get_resource_stats_history
Retrieve Azure SQL Database resource utilization history with 15-second granularity, showing CPU, data I/O, log write, memory trends and sustained pressure warnings to diagnose performance issues.
Instructions
Get resource utilization history (15-sec granularity) from sys.dm_db_resource_stats. Shows CPU, data I/O, log write, memory trends with sustained pressure warnings.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | Optional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE. | |
| window_minutes | No | How far back to look, in minutes. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||