Forum Discussion

Jerome22's avatar
Jerome22
Icon for Resolver I rankResolver I
2 years ago

Why is there CU usage while no activity running?

I'm checking the capacity report to try to understand the usage. but I found that I have a constant 12CU(s) consumed all the time. in the middle of the night, when I have nothing running, CU(s) are...
capacities
Jerome22's avatar
Jerome22
Icon for Resolver I rankResolver I
1 year ago

I sent a example:

I have 0.625CU consumed for 24h, related to a pipeline which consumed 1800CU. 

so this background activity will cost me 54 000CU per 24h for something which cost only 1800CU during its execution and was burndown in seconds.

 

0.625 * 60 * 60 * 24 = 54 000 CU in total

if the impact on my capacity is 0.625, this activity should consumed my capacity for 48 minutes

0.625 * 60 * 48 = 1800

else I expect, 1800 / (24 * 60 * 60) = 0.0208 CU consumed for 24h

 

for my lakehouse, yes, I had activities 10 days ago, nothing after that.

it's just an example, I'm seeing activities poping from everywhere.

 

remember: I'm reaching 200 000 + background activities!!! 

just by running few pipelines a day, nothing complicated. and the number of user is pretty low for now (mainly myself and few people running 5 reports in the day)

 

frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
1 year ago

On my trial capacity (I am the only user), I have 75 000 background activities being smoothed at the moment. It doesn't mean any of these background activities are running now. This is the number of background activities which ended during the last 24 hours. 

 

These 75 000 background activities are costing me 10% of my trial capacity.

 

 

"I have 0.625CU consumed for 24h, related to a pipeline which consumed 1800CU. 

so this background activity will cost me 54 000CU per 24h for something which cost only 1800CU during its execution and was burndown in seconds."

I am guessing the Total CU (s) is 1800CU.

0.625 CU (s) / 30 s * 60 s/min * 60 min/h * 24 h = 1800CU (s).

So I am guessing you will pay in total 1800CU (s).

I think this makes sense.

 

The Total CU (s) is the cost of the operation. I don't think you will pay 54000CU. I think you will pay 1800CU (s). What makes you think 54000CU is the amount you will pay?

 

 

I think these two visuals (red boxes) are the ones which provide the most useful information. Here we can find the actual resource usage, and what day and what hour the usage really happened. Yes, it will be billed over a 24 hour period after the usage actually happened. But these two visuals show when the usage actually happened, which I prefer.