About CU%

[TotalAnonymous]

Dear Community, 

I hope you're doing well

I have been given information about the capacity from the global admin as follows:

I also have given this information

We're using P1 capacity. Do you have any suggestion where can I start from this kind of information? How should I do?

Thank you

[TotalAnonymous]

Thanks for your response, @v-ssriganesh and @Akash_Varuna. Please give me a week to assess your answer as I'm currently thinking about the plan to optimize this. Thank you

[v-ssriganesh]

Hi @TotalAnonymous,
Thank you for reaching out to the Microsoft fabric community forum.

Also, a big thanks to @Akash_Varuna for the great insights. To expand on this, based on your CU% and performance reports:

• Review the CU% over time graph to pinpoint when usage spikes occur. Identify if high usage comes from interactive queries (red) or background processes (blue).
• If interactive queries dominate, consider optimizing reports that rely on complex calculations.

• Your table shows high CU queries with long durations these might be impacting performance. Focus on queries with negative performance deltas (highlighted in red) and optimize them

• Use the Power BI Capacity Metrics App to track performance trends and identify problem areas. Set up alerts to notify you when CU% is nearing the limit.
  
  For your reference:
  https://learn.microsoft.com/en-us/fabric/enterprise/metrics-app
  https://learn.microsoft.com/en-us/fabric/admin/service-admin-premium-capacity-notifications
  
  

If 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.

[Akash_Varuna]

Hi @TotalAnonymous The problem of high CU% and performance issues due to spikes in workloads. You could try these:

1. Analyze capacity metrics and identify workload spikes.
2. Optimize resource-heavy queries and adjust refresh schedules.
3. Enable Autoscale to handle temporary load increases.
4. Monitor CU% and performance regularly to address issues proactively.