Deep Dive into Microsoft Fabric Capacities: Fundamentals, Concepts, and Advanced Strategies
Proposed session for SQLBits 2026TL; DR
Microsoft Fabric capacities are powerful, flexible, and—at times—deeply intricate. In this advanced session, we’ll unpack the full lifecycle of capacity behavior, starting with the fundamentals: how bursting delivers peak performance beyond SKU limits, how smoothing spreads compute usage across timepoints, and how throttling protects shared resources under sustained load. Building on these core mechanisms, we explore advanced capacity operations including pausing and resuming workloads, scaling capacities up or down, and making effective use of reservations for predictable cost control.
We’ll then shift to data‑driven optimization strategies, using real usage patterns to diagnose overloads, interpret smoothing debt, and identify when performance bottlenecks require tuning or scaling. You’ll learn how to leverage Fabric’s built‑in metrics, including insights from the Capacity Metrics App and platform telemetry, to develop a proactive, evidence‑driven monitoring approach. By the end of the session, you'll be equipped to operate Fabric capacities with confidence—balancing performance, governance, and cost in complex enterprise environments.
Session Details
Microsoft Fabric capacities are powerful, flexible, and at times deeply intricate.
In this advanced session, we’ll unpack the full lifecycle of capacity behavior, starting with the fundamentals: how bursting delivers peak performance beyond SKU limits, how smoothing spreads compute usage across timepoints, and how throttling protects shared resources under sustained load.
Building on these core mechanisms, we explore advanced capacity operations including pausing and resuming workloads, scaling capacities up or down, and making effective use of reservations for predictable cost control.
We’ll then shift to data‑driven optimization strategies, using real usage patterns to diagnose overloads, interpret smoothing debt, and identify when performance bottlenecks require tuning or scaling.
You’ll learn how to leverage Fabric’s built‑in metrics, including insights from the Capacity Metrics App and platform telemetry, to develop a proactive, evidence‑driven monitoring approach.
By the end of the session, you'll be equipped to operate Fabric capacities with confidence—balancing performance, governance, and cost in complex enterprise environments.
In this advanced session, we’ll unpack the full lifecycle of capacity behavior, starting with the fundamentals: how bursting delivers peak performance beyond SKU limits, how smoothing spreads compute usage across timepoints, and how throttling protects shared resources under sustained load.
Building on these core mechanisms, we explore advanced capacity operations including pausing and resuming workloads, scaling capacities up or down, and making effective use of reservations for predictable cost control.
We’ll then shift to data‑driven optimization strategies, using real usage patterns to diagnose overloads, interpret smoothing debt, and identify when performance bottlenecks require tuning or scaling.
You’ll learn how to leverage Fabric’s built‑in metrics, including insights from the Capacity Metrics App and platform telemetry, to develop a proactive, evidence‑driven monitoring approach.
By the end of the session, you'll be equipped to operate Fabric capacities with confidence—balancing performance, governance, and cost in complex enterprise environments.
3 things you'll get out of this session
- Understand Core Capacity Mechanics
- Master Advanced Capacity Operations
- Apply Advanced Monitoring Strategies
Speakers
Benni De Jagere's other proposed sessions for 2026
A Whirlwind Tour of the Fabric Capacity Metrics App - 2026
Copilot in Fabric - Explained for the Administrator! - 2026
Demystifying the on-premises data gateway (for Power BI Semantic Models) - 2026
End-to-end Monitoring for Microsoft Fabric - 2026
Exploring permission boundaries in Microsoft Fabric - 2026
Fabric Capacities, beyond the obvious - 2026
Panel Debate: Real-World Microsoft Fabric Administration - Lessons from the Trenches - 2026
Slide Karaoke - Ultimate Showdown! - 2026
Star Schema ALL the things! But why? - 2026
Understanding Fabric Capacities - 2026
Benni De Jagere's previous sessions
Nose-Dive Narratives: Slide Karaoke 2024
Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!
Asking questions to get meaningful answers
By making sure we're supplying the other party with the compact information they need, and making sure we're "forcing" them to give a decent answer, there's a lot more information we can receive. By getting the information we need, we'll be able to proceed quicker, and getting to results faster.
Setting yourself up for success when submitting to present
During this session we'll cover how you find those elusive speaking opportunities and how you can make the most of it with just a few simple things to keep in mind. Most importantly, what can you do to help understand organizers or selection committees why exactly your session would be a good fit for them, and why you think it would be a good fit for their audience.
Star Schema ALL the things! But why?
Come along in this journey from source to model to report using a practical mindset, thinking about the design decisions and ramifications along the way. At the core of the session lies the message to think about best practices, with the added step to test, assess, and benchmark what exactly they do for you.
You're a Power BI Admin? Let's get your threads aligned for Fabric!
This session will focus on the life of a Power BI Admin moving over to the extended Fabric realm, and keeping their things in check. We'll look at the familiar topics of capacity and workspace management, and how they align with the new workloads that have been introduced. We'll notice there's a very large overlap, as Fabric has been built on the foundations of Power BI.