Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: ✅ SQL analytics endpoint and Warehouse in Microsoft Fabric
This article details the concepts of smoothing and throttling in workloads using Warehouse and SQL analytics endpoint in Microsoft Fabric.
This article is specific to data warehousing workloads in Microsoft Fabric. For all Fabric workloads and general information, see Throttling in Microsoft Fabric.
Capacity forms the foundation in Microsoft Fabric and provides the computing power that drives all Fabric workloads. Based on the Capacity SKU purchased, you're entitled to a set of Capacity Units (CUs) that are shared across Fabric. You can review the CUs for each SKU at Capacity and SKUs.
Capacities have periods where they're under-utilized (idle) and over-utilized (peak). When a capacity is running multiple jobs, a sudden spike in compute demand might be generated that exceeds the limits of a purchased capacity. Warehouse and SQL analytics endpoint provide burstable capacity that allows workloads to use more resources to achieve better performance.
Smoothing offers relief for customers who create sudden spikes during their peak times while they have a lot of idle capacity that is unused. Smoothing simplifies capacity management by spreading the evaluation of compute to ensure that customer jobs run smoothly and efficiently.
Smoothing won't affect execution time. It helps streamline capacity management by allowing customers to size your capacity based on average, rather than peak usage.
In general, similar to Power BI, operations are classified either as interactive or background.
Most operations in the Warehouse category are reported as background to take advantage of 24-hour smoothing of activity to allow for the most flexible usage patterns. With 24-hour smoothing, operations can run simultaneously without causing any spikes at any time during the day. Customers get the benefit of a consistently fast performance without having to worry about tiny spikes in their workload. Thus, classifying data warehousing as background reduces the frequency of peaks of CU utilization from triggering throttling too quickly.
Most Warehouse and SQL analytics endpoint operations only experience operation rejection after over-utilization averaged over a 24-hour period. For more information, see Future smoothed consumption.
Unable to complete the action because your organization's Fabric compute capacity has exceeded its limits. Try again later
.Unable to complete the action because your organization's Fabric compute capacity has exceeded its limits. Try again later
.Review actions you can take to recover from overload situations.
Capacity administrators can view overload information and drilldown further via Microsoft Fabric Capacity Metrics app.
For a walkthrough of the app, visit How to: Observe Fabric Data Warehouse utilization trends.
Use the Microsoft Fabric Capacity Metrics app to view a visual history of any overutilization of capacity, including carry forward, cumulative, and burndown of utilization. For more information, refer to Throttling in Microsoft Fabric and Overages in the Microsoft Fabric Capacity Metrics app.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Monitor a Microsoft Fabric data warehouse - Training
A data warehouse is a vital component of an enterprise analytics solution. It's important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.
Certification
Microsoft Certified: Fabric Data Engineer Associate - Certifications
As a Fabric Data Engineer, you should have subject matter expertise with data loading patterns, data architectures, and orchestration processes.
Documentation
Evaluate and optimize your Microsoft Fabric capacity - Microsoft Fabric
This article explains how to evaluate and optimize the load on your Microsoft Fabric capacities.
Data warehouse billing and utilization reporting - Microsoft Fabric
Learn more about utilization reporting for the data warehouse, including capacity and compute usage reporting.
Burstable capacity - Microsoft Fabric
Learn more about how burstable capacity is used and limited with SKU guardrails in Fabric data warehousing.