Sudden spike in database size

0
Recently we have had unexpected sudden spikes in the database size of one our applications.   We have already downloaded a backup of the production data to try to query the tables for bad data.   Has anyone got any suggestions, tips or tools that would assist in our investigations of the root cause?
asked
3 answers
0

First check which tables can account for the unexpected growth and then try to corrrelate this to available functionality that could influence this.

Also check if the growth is still present after restoring the database locally. If the size has reduced significantly you might be dealing with bloating and need to identify the code that is responsible for creating/updating/deleting data excessively.

Tip: Try google for finding SQL statements for table sizes and bloating, they are readily available.

answered
0

Many thanks everyone

answered
0

To see an actual reduction in the database after deleting records will need to recover the physical disk space.

Reducing Database Size | Mendix Documentation

 

answered