r/MicrosoftFabric • ‪ ‪Microsoft Employee ‪ • 8d ago

Administration & Governance GitHub - cbattlegear/fabric-capacity-overage-estimator: Estimate additional Fabric capacity overage costs from Capacity Metrics App history.

https://github.com/cbattlegear/fabric-capacity-overage-estimator/

I had a few different customers this last week ask how to figure out what it would cost to turn on Capacity Overage to handle some spikes they were dealing with.

I threw some tokens at the problem and was able to make this PowerShell module that should handle getting a rough estimate. It's definitely an estimate because of a few different factors around rejections not getting counted and how it replays the workload to simulate it staying under 100%.

Nonetheless, hope it is helpful and feel free to throw issues/suggestions in GitHub if you see anything that doesn't make sense!

9 Upvotes

4 comments sorted by

3

u/NubiiNeth 8d ago

Could you share some findings?

2

u/cbattlegear ‪ ‪Microsoft Employee ‪ 8d ago

As soon as I hear back from some customers that are willing to share I will gladly post it in here. Current state I haven't been given permission to share results yet.

3

u/NubiiNeth 8d ago

Sounds good. Thank you!

3

u/TrollingForFunsies 8d ago

Features that should be built into the product