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

[Akash_Varuna · Accepted solution]

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.

[v-ssriganesh]

Hi @TotalAnonymous,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @TotalAnonymous,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

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 · Accepted solution]

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.

[v-ssriganesh]

Hi @TotalAnonymous,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.

[Akash_Varuna · Accepted solution]

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.