Forum Discussion
Dataflow gen2 high CU usage
One of my gen2 dataflows uses relatively too much (i think) CU's for what it does: I take 3 tables from warehouse, check max date and filter each of another 3 tables from on prem sql server source b...
My situation is not quite the same but what I am seeing is that after refreshing, usage remains high even though no one is doing anything. I suspect the back end resource recovery is not working correctly or optimally.
I am using about 10% of trial capacity, what should be equal to F64. And fabric still shows "usage" also when nothing runs - what i understand, this is just how it works. I hope that i am not wrong here with my math, but this is how i am planing for capacity purchase: 4 CUs * 60s * 60min * 24hrs is 345 600 CUs total, so my daily workloads have to not exceed that. By the way, You can edit capacity metrics app in service, i added my custom date slicer so i could monitor one day usage
