Forum Discussion

Hussein_charif's avatar
7 months ago
Solved

Increasing Capacity

Hello all,

i wanted to get professional opinion on upgrading our Capacity. so, here is what we currently have :

 

we are currently on an F16 capacity with 10 users, we have around 30 dataflows with small amount of data extracted from Business central that run 4 times a day(takes 15 minutes in total), we have 2 dataflows with medium load, that run 6 times a day(each dataflow takes 40minutes approximately), we have 3 pipelines that run every 3 minutes, those pipelines do an incremental refresh getting data from dataverse, each run takes 30seconds-1min, we have 6 reports, all direct query, and multiple paginated reports created and extracted daily by multiple users, we currently have in total in our fact table around 70 columns, nearing 30 million records increasing daily by ~ 1.8m to 2m. the average CU usage is 50-70%, and sometimes when multiple paginated reports are being created and extracted, the throttling % goes over the 100% limit.

 

we have over 30 new users pending to have access on the reports and paginated reports.

 

i was aiming to increase the capacity to F64, for multiple reasons being reducing capacity usage; having some breathing space for the capacity with the CPU/memory increase, and the new and existing users wont need a license since on F64 users with viewer access can view the reports and paginated reports without a license.

 

is that a good option to go with? would love to hear any professional's perspective on this!

 

thank you in advance!

9 Replies

  • Benefits of moving to F64:

     

    1. Massive headroom increase

    Compared to F16, F64 gives you:

    • 4× CPU

    • 4× memory

    • Much higher concurrency tolerance

    This directly addresses:

    • Throttling during concurrent paginated exports

    • Overlaps between refresh + pipelines + user activity

     

    2. License simplification

    On F64:

    • Viewers do not need Pro or PPU licenses

    • This is ideal with 30+ new users pending

    • Especially valuable if users consume:

      • Reports

      • Paginated reports

      • Subscriptions

    This alone can justify the upgrade financially.

     

    3. Growth protection

    Given your data growth rate:

    • 2M rows/day ≈ 60M rows/month

    • You’ll likely double your fact size in months, not years

    F64 gives you runway, not just relief.

  • v-echaithra's avatar
    v-echaithra
    Community Support

    Hi Hussein_charif ,

    I just wanted to check if the issue has been resolved on your end, or if you require any further assistance. Please feel free to let us know, we’re happy to help!


    Thank you 
    Chaithra E.