Dynamics Community Forum Thread Details

Database capacity issue due too high volume of data and relatively few users/licenses

Hi All,

I work for a company with relatively few users (licenses) and a lot of transactions. Most of the work is automated. Furthermore we have 4 environments:

Production

Pre-Production

UAT (Test)

DEV (UDE environment)

We're at the end of our database capacity and the ridiculous amount of $40 per Gb per month MS is asking is just too much as we will need at least 200 GB for the next 2 years. I really find this amount outrageous. An amount around $4 would be more appropriate.

The major part of the data is in the sales orders, picking lists, packing slips, invoices and all related tables like inventTrans.

I already created a job that removes a lot of transactional data from non-production environments. Although this helps it's just not enough.

Using Archiving (dataverse or BYOD) is not really an option as the data is pretty young (2024-now). And this will also (partially) move costs to Azure BYOD or DataVerse. Furthermore it would require a big redesign of PowerBi and other tools we're using.

We tried talking to MS to negotiate a different amount, but so far they're not really helping us.

I guess I'm not the only one. Are there other users here with similar issues ? What did you do to solve this ?

Thanks !!

Gerard

Categories:

Dynamics 365 Finance

Hi Gerard,

You haven't provided that many details. Managing database capacity requires a holistic overview of the processes and the current consumption per table. Are you talking about F&O database usage or Dataverse? Depending on details, there can be a lot more that you can cleanup.

I have done several cleanup assessments and currently working with an organization which are over 4 TB on top of the entitled capacity. At this client, I think we can get them within database entitlement.

I do agree that database capacity is expensive, but there is more involved than just storage. Have you checked the top 50 tables for database consumption? At the client I'm working on, next to sales orders and inventory transactions, there are other tables responsible for the database growth.

Quick Links