Question

A data engineer manages a Fabric Warehouse that has been experiencing slow report performance during business hours. Before optimizing, the engineer needs to identify which completed and currently running queries are consuming the most CPU and running the longest, using built-in Fabric tooling without setting up external monitoring. What should the engineer use?

Accepted Answer

Query the queryinsights schema views (such as queryinsights.exec_requests_history) in the Warehouse

Answer

Enable Azure Diagnostic settings and stream logs to a Log Analytics workspace

Answer

Open the Capacity Metrics app and drill into the Spark utilization timeline

Answer

Run VACUUM and OPTIMIZE on the Warehouse tables to compact small files