topic Re: Minimum CU (s) billing per copy? Or am I just bad at maths? in Pipelines

Minimum CU (s) billing per copy? Or am I just bad at maths?

datafabricator — Wed, 22 May 2024 15:26:04 GMT

Hi,

Please help me make sense of the CU (s) numbers reported by the Fabric Capacity Monitoring app for a pipeline run.

What am I getting wrong?

A tiny pipeline with 5 copies (and 1 SP call). The copy acitivities barely copy any data, i.e. <100 rows each. Takes a couple of seconds each. See screenshot for relevant rows from backgrund ops. matrix in the app's timepoint page.

I've read through the pricing documentation, and it says Data Movement (for our copy activies) should cost 1.5 Capacity Units per hour.

So how does a duration of 30 seconds work out to 360 total CU (s)?

In my eyes:

1.5 CU per hour gives 0,0004166 CU per second.
Say 30 s duration. 30 * 0,0004166 = 0,0125.
Now how many intelligent optimization throughput resources are used? Was set to auto, so unclear.
But even assuming a maximum of 256, we only get 256 * 0,0125 = 3,2 CU (s). Far from listed 360!

Also seems to report 360 CU (s) irrespective of copy activity duration if it's small enough. Same 360 CU (s) minimum for another project I've checked with.

Am I calculating it wrong, or is there a minimum CU (s) for each copy activity?

(Related to some minimum billing interval? Working with a pay-as-you-go F8, it's enabled 24/7.)

Re: Minimum CU (s) billing per copy? Or am I just bad at maths?

Anonymous — Thu, 23 May 2024 07:49:33 GMT

Hi datafabricator ,

Thanks for using Fabric Community.
The best place to get an answer to this question is here.

Please feel free to ask your query in Microsoft Fabric Pricing portal.

Hope this is helpful. Do let me know in case of further queries.

Re: Minimum CU (s) billing per copy? Or am I just bad at maths?

KobeLenjou2 — Tue, 23 Jul 2024 07:28:41 GMT

Hi datafabricator ,

Did yo ever got a real answer on this? I'm having the exact same question, and the pricing page linked in the answer does not really answers this question.

Greets

Kobe

Re: Minimum CU (s) billing per copy? Or am I just bad at maths?

ANILKB — Sun, 08 Dec 2024 23:48:00 GMT

Here 48 seconds run will be rounded off to 1 minute. Total CU (s) = 60 seconds * 4 (with 4 DIU setting) x1.5 CU/hour= 360.0000 CU's.

Total pipeline charges will be: will need to convert CU's into hours which is 360/3600 = 0.1 CU. Assuming you're using F2 capacity, charges will be 0.36$/hour(based on the region)- doc here-Microsoft Fabric - Pricing | Microsoft Azure. So that final calculation will be 0.1 * 0.36 = 0.036$.

Note: This callcuation is based on the Pay-as-you-go (hourly) model.