Microsoft Fabric Capacity Metrics: Identifying Spikes in Premium and Fabric Capacity
Microsoft Fabric Capacity Metrics is a powerful tool designed to provide monitoring capabilities for Microsoft Fabric capacities1. It allows you to monitor your capacity consumption and make informed decisions on how to use your capacity resources1. This article will delve into the details of identifying spikes in Premium and Fabric Capacity, with a particular focus on background and interactive operations.
Understanding Interactive and Background Operations
Microsoft Fabric divides operations into two types: interactive and background1.
Interactive Operations
Interactive operations are on-demand requests and operations that can be triggered by user interactions with the UI, such as data model queries generated by report visuals1. They’re usually triggered by user interactions with the UI. For example, an interactive operation is triggered when a user opens a report or clicks on a slicer in a Power BI report1. Interactive operations can also be triggered without interacting with the UI, for example when using SQL Server Management Studio (SSMS) or a custom application to run a DAX query1.
