I recently joined as the FinOps lead and I'm trying to get a handle on our Azure spending, specifically regarding our multiple databases in elastic pools. The challenge is that Azure Cost Management only presents costs at the pool level, which doesn't aid in reallocating expenses to different teams. I've explored DTU and vCore usage metrics, but can't correlate that back to dollar amounts for each individual database. Has anyone found a reliable method to do this? Are there custom scripts or third-party tools available that provide defensible numbers for internal billing?
3 Answers
You could try averaging the CPU usage per database from the last week and factor in the storage size too. That might give you a closer estimate for allocation.
Unfortunately, Azure doesn’t provide per database costs when using elastic pools since it's inherently a shared model. You’ll have to devise your own allocation logic based on DTU or vCore metrics and distribute pool costs accordingly. Tools like PointFive can help automate this cost attribution if you set up tagging and allocation rules.
You might want to keep in mind that elastic pools are designed around shared capacities. So, accurately reflecting a dollar value on a per-database basis can be tricky unless you just divide the total instance cost by the number of databases. If clear cost representation is crucial, hosting each database on dedicated or serverless plans could be a better route.

Related Questions
Biggest Problem With Suno AI Audio
Ethernet Signal Loss Calculator
Sports Team Randomizer
10 Uses For An Old Smartphone
Midjourney Launches An Exciting New Feature for Their Image AI
ShortlyAI Review