sqldw-operations-cli - Analyze Fabric Data Warehouse performance
Analyzes Fabric Data Warehouse performance with sqlcmd and queryinsights to diagnose slow queries, resource pressure, cache coldness, and clustering needs.
Tags
Updated: 2026-10-15Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Analyze slow queries
- Identify resource consumers
- Diagnose SQL pool pressure
- Assess cache warmth
- Recommend clustering keys
- Compare performance baselines
- Analyze user query patterns
- Discover warehouse endpoints
- Execute read-only T-SQL queries
Inputs
- Workspace name or ID
- Warehouse name or ID
- Entra ID authentication
- Recent warehouse query activity
Outputs
- Performance analysis
- Diagnostic findings
- Optimization recommendations
- Read-only query results
Requirements
- sqlcmd (Go)
- Azure CLI
- jq
- Entra ID authentication
- Fabric Data Warehouse
- Admin or Member workspace role
- Recent warehouse query activity