Forum Discussion
Resolver IWhy is there CU usage while no activity running?
Resolver II understand all of this.
But I'm not overconsuming
the problem is: the cumulative smoothing is about 10 times the cost of the initial activity.
even interactive activities stay in background for 24hours (any single SQL query...)
add to that activities coming from nowhere, like a lakehouse not used for the past weeks start consuming CUs for no reason.
and boom, you have 200 000+ background activities for 24hours consuming more than the available capacity.
its really crazy.
I hope that Microsoft will solve that, as they recognize the issue.
wait and see... but they have to solve this ASAP, has this cost us a lot of money
Community ChampionSQL queries are counted as background queries and are smoothed for 24 hours. https://learn.microsoft.com/en-us/fabric/enterprise/fabric-operations#data-warehouse
"the cumulative smoothing is about 10 times the cost of the initial activity." Can you describe how you found this number?
"add to that activities coming from nowhere, like a lakehouse not used for the past weeks start consuming CUs for no reason." What kind of transactions are you being billed for? Is it OneLake read transactions? This can be found in the Items (14 days) visual. Is the Lakehouse being queried? E.g. are some Power BI reports using the Lakehouse data, or some other processes using the Lakehouse data?
"I did extensive analysis of these background operations.
they starts as soon as I pause and resume my instance, before conducting any type of activity." What kind of operations are these? Is it SQL queries, dataflow gen2, spark notebook, pipeline, etc.?
"like currently I have 0.625CU consumed by a process terminated yesterday (a pipeline), the dataflow consumed 1800CU, paid yesterday." Background operations are smoothed for 24 hours after they finish. It's normal that operations from yesterday are still showing in the Timepoint page.
"and a consumption during this time greater than the activity itself." Can you describe what you mean by greater than the activity itself? How do you know the consumption of the activity itself? And where do you see that you are smoothed for more consumption than the activity itself?