Smoothing currently balances the CUs required to complete background tasks across 24 hours. This often means that overnight we are under-utilising our capacity and offsetting some of the load to our peak usage period during the day. Since the peak period also includes many interactive processes, smoothing is actually creating usage peaks right when we are using the processes which are most impacted by those peaks.
We should be able to control smoothing by setting a percentage of capacity that can be utilised by background processes. If background usage is below this figure the spare capacity should then be used to speed up background processing.
Example: Consider a 6 CUhr background operation starting at midnight. Currently, it would consume 0.25 CUhr per hour for 24 hours. Running an F2 Sku, I set my Background Processing Limit to 50% between 00.00 and 06.00. Now the operation consumes 1 CUhr per hour for 6 hours and no consumption for the remaining 18 hours.
1 Comment
Recent ideas
Not found value "Available gateway clusters"
Hi, Currently the machine (A) hosting power BI on-prime gateway standard. Machine (B) also want to host this server with machine (A). Gateway on (A) and (B) is using the same tenant as admin user. I...Thas_Michael15 hours agoHelper INew7Views1like0CommentsFabric Deployment Pipeline Should Automatically Preserve or Upgrade Semantic Model Compatibility
Category: Microsoft Fabric — Deployment Pipelines | Semantic Models | Direct Lake The Problem When deploying a Direct Lake semantic model containing calculated columns or calculated tables throug...Murtaza_Ghafoor16 hours agoSuper UserNew3Views0likes0CommentsAdd standard ADBC search paths for ADBC drivers in Power BI
Considering the benefits of using ADBC drivers for data intensive operations, it would be nice to allow ADBC drivers to be used that are not necessarily packaged with Power BI installations. To mitig...hsadlier-pdx1 day agoNew MemberNew6Views0likes0Comments