Fabric capacity metrics

Hey there!

Here’s an explanation of the typical color-coding in capacity metrics:

• Red Line: This generally indicates a threshold where your capacity has reached a critical level. In your case, the red line likely represents the maximum capacity (usually 100% usage). When your usage reaches this point, reports may start to slow down, fail to load, or become less responsive.

• Orange Line: This typically represents a warning threshold, usually at a level lower than the red line (often around 70% or 80%). The orange line indicates that you're approaching full capacity and that performance degradation could happen if usage continues to increase. In your case, you’ve received the message that your capacity is at 70%, so this orange line likely represents this warning point.

How to resolve the problem:

1. Reduce Usage:

   • Review your usage and reports. Try to identify heavy queries, large datasets, or inefficient visuals that might be consuming excessive resources. Optimize your reports to reduce load times and improve responsiveness.

2. Enable Autoscaling:

   • If autoscaling is available in your plan, enable it. This feature automatically adjusts the resources to meet the demand during high usage periods. This could help avoid performance issues as the demand fluctuates.

3. Consider Upgrading:

   • If you consistently run into capacity issues, consider upgrading to a higher capacity plan to avoid hitting the usage limits regularly.

4. Optimize Data Models:

   • Check your data models and reports for inefficiencies. Large tables, unnecessary calculations, or high-cardinality columns can all slow down performance and increase capacity usage

By addressing these areas, you should be able to optimize your usage and avoid performance degradation.

Hope this helps!

😁😁

Hi SLI,
Thank you for reaching out to the Microsoft Fabric Forum Community and also thank you to freginier for the detailed explanation.

To answer your question:

The 70% warning refers to capacity usage (CU%) and not storage.

• Capacity Usage (CU%) measures the compute power used for workloads like dataset refreshes, report queries, and notebooks.
• Storage Usage is separate and refers to the amount of data stored in OneLake.

To monitor One Lake storage usage, use the Fabric Capacity Metrics app and filter by Lake in the Storage tab.For more details, refer to the official documentation: OneLake Capacity Consumption

If you find this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.