100% Background CPU %

[cassidy]

Starting yesterday afternoon, on our P1 US - West Capacity, we moved from our baseline of 40-50% Background CPU % to 100%+ Background CPU non-stop.  It's been 16 Hours at 100% (really 107%).

Our Refreshes of Datasets and Dataflows are going as normal.  Report interaction and querying is very poor.

I've been a bit confused by this rollout (as were the commenters) and was curious if what I'm seeing is related:

https://powerbi.microsoft.com/en-us/blog/simplifying-capacity-management-with-unified-v-cores/

Has anyone else in the US - West experienced a jump in Background CPU % since yesterday?

I'm checking Capacity Metrics Analysis frequently, but it's not really showing anything abnormal other than the spiked Background CPU %

Thank you.

[GilbertQ]

HI @cassidy 

Yeah that sounds like something is either querying your dataset and trying to extract a lot of data or something else is going on.

What happens if you go into the datasets using the XMLA end points and then use SQL profiler to see if maybe there are long queries running?

Other than that the only other option is to log a support ticket?

[cassidy]

I wish I would of thought of that in the moment, we have since returned to normal Backend CPU %.

I did open a Support Ticket at the time as well, but they have not been able to give any insight outside of what the Capacity Utilization Metrics already show.

@GilbertQ , if you happen to know, I was mostly paying attention to the below graph and I understood the Red as Users querying the Dataset and Blue as things like Refreshes of Datasets/Dataflows.  If someone was excessively querying the Datasets, wouldn't the graph show Red pushing past 100%, while Blue stays stable/lower?

• Interactive CPU - Red columns represent the number of CPU seconds used during interactive operations in a 30 second period.

  Interactive operations cover a wide range of resources triggered by Power BI users. These operations are associated with interactive page loads.

• Background - Blue columns represent the number of CPU seconds used during background operations in a 30 second period.

  Background operations cover Power BI backend processes that are not directly triggered by users, such as data refreshes.

[GilbertQ]

Hi @cassidy 

It could possibly be multiple dataset refreshes happening?

As far as I can recall the background operations are averaged over a 24 hour periods?

Here is the learn document: Power BI Premium Gen2 capacity load, overload, and autoscale - Power BI | Microsoft Learn

I would also have logging enabled to Log Analytics which would allow you to see if users are running queries and how long they are running for?