get_object_index_diagnostics
Diagnose index health with insights into read/write usage, buffer footprint, lock waits, and columnstore row groups, enabling targeted index optimization.
Instructions
Get object and index diagnostics: write-heavy nonclustered indexes, read/write usage, buffer footprint, volatile stats, columnstore row groups, index lock waits, and resumable index rebuilds.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum rows per detail section. | |
| table_name | No | Optional table filter. | |
| schema_name | No | Optional schema filter. | |
| database_name | No | Optional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||