get_table_health_metrics
Detect Delta/Parquet layout issues in SQL Analytics Endpoints by retrieving table health metrics, revealing small files, fragmentation, and excessive deletes.
Instructions
Return health metrics for a table via sp_get_table_health_metrics.
Only supported on SQL Analytics Endpoints (not Data Warehouses). The proc surfaces Delta/Parquet layout issues such as small files, fragmentation, excessive deletes/updates, and delayed checkpoints.
The stored procedure is Generally Available (announced at Build 2026) but its output column schema is not yet documented by Microsoft. Columns and rows are passed through verbatim.
Args:
workspace: Workspace name or GUID.
item: SQL Analytics Endpoint name or GUID. Data Warehouses are
rejected with a ToolError.
qualified_name: Dot-separated qualified table name, e.g. dbo.sales.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| item | Yes | ||
| workspace | Yes | ||
| qualified_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||