If warehouse queries degrade in performance due to throttling, which app should you use to identify throttling?

• A. Azure Monitor
• B. Power BI Performance Analyzer
• C. SQL Server Profiler
• D. Microsoft Fabric Capacity Metrics app

Answer: (D)

Throttling happens when resource demand exceeds what the system can safely provide, so queries slow down or get limited to protect overall performance. In a Fabric data warehouse, you’ll detect throttling by looking at capacity usage and any throttle signals across your deployed capacities. The Microsoft Fabric Capacity Metrics app is designed for this exact purpose: it surfaces capacity utilization, active queries, queue lengths, and throttle events, letting you quickly see if degraded warehouse performance is due to throttling rather than a poorly optimized query or a separate issue. With this insight, you can decide to scale capacity, reallocate resources, or adjust workloads. Other tools exist for general monitoring or for tracing SQL activity, but they don’t target Fabric throttling telemetry as directly or comprehensively.