Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
cassidy
Impactful Individual
Impactful Individual

100% Background CPU %

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.

3 REPLIES 3
GilbertQ
Super User
Super User

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

cassidy
Impactful Individual
Impactful Individual

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?

cassidy_0-1671122057193.png

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

 

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors