Oct 13 in Technical
Estimating Capacity Size
Hey everyone,
I am currently using a Fabric Trial License (FT1) and I was wondering what is the best License to get given my current consumption.
I have attached a screenshot of my Fabric Capacity Metrics and I can see the highest total usage occurred on 1st October @ 10:31.
I used 91.27 CU: (Interactive CU: 9.97, Background CU: 81.3) in a 30 second period.
This seems to indicate I need a F4 SKU? As 91.27/30 = 3.04....
However, I notice that my background consumption was highest a few minutes later at 83.87 CU in a 30 second period. Whereas my interactive CU was highest on 10th October at 78.48 CU in a 30 second period.
The sum of these two highs returns a 162.35 CU, which would indicate I need a F8 SKU? As 162.35/30 = 5.41..
Which SKU do you think I need?
Furthermore if I want to reduce my consumption, how would I go about doing this?
For background operations when I drill-through at the highest consumption point I see multiple runs of my notebook for different periods. Why?
For interactive operations I see a Query which ran 5 minutes before the drill-through time. Why?
Any help would be much appreciated.
1
3 comments
Estimating Capacity Size
skool.com/microsoft-fabric
Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.
Leaderboard (30-day)
1
+42
2
+36
3
+34
4
+28
5
+26
powered by