sqldw-operations-cli

Query the queryinsights.long_running_queries view ordered by total_elapsed_time_ms to find the slowest queries. Connect with sqlcmd using Entra ID authentication (the -G flag) and run the provided T-SQL to get execution counts, last run time, and median duration.

Use the queryinsights.sql_pool_insights view to identify pressure windows where is_pool_under_pressure equals 1, then correlate those windows with the heaviest overlapping queries from exec_requests_history. The skill provides a two-step query that consolidates consecutive pressure events into windows.

Querying queryinsights views requires an Admin or Member role on the target Fabric workspace. The views are always enabled and retain 30 days of history, with data appearing up to 15 minutes after query completion.

No, Fabric Data Warehouse does not support ALTER TABLE SET DATA_CLUSTERING_KEY. Instead, create a clustered copy using CTAS with WITH (CLUSTER BY (...)), swap tables with sp_rename, and verify clustering via sys.index_columns.data_clustering_ordinal.

Empty results usually mean the warehouse is less than two minutes old, no queries ran recently, or the 15-minute data delay has not elapsed. Permission errors instead indicate insufficient workspace role, and row-level security can also filter results.