Fabric Data Warehouse is adding richer graphical query plans and AI-assisted performance diagnostics. A common production problem is identifying when a previously healthy query becomes expensive after a deployment, schema change, statistics change, or significant data growth. Please add automatic query plan regression detection to Fabric Data Warehouse. Fabric should maintain a performance baseline for frequently executed queries and compare new executions against previous healthy plans. The comparison should identify major changes in joins, scans, data movement, cardinality estimates, memory requirements, execution duration, and resource consumption. When a regression is detected, Warehouse Monitor should show the previous and current plans side by side and highlight the operators responsible for the change. Administrators should also be able to configure regression thresholds and receive alerts when a critical production query exceeds its normal performance range. This would help teams detect query regressions before they become user-facing performance incidents.
No CommentsBe the first to comment
