We noticed our Audit Database size increased from 0.72 GB to 10.17 GB after completing a TP DB cleanup (with archiving) in our TEST environment.
Above is a screen shot showing pre-cleanup and post-cleanup states for the database tables.
A few questions:
1. Is this increase in size for the Audit tables normal?
2. What effect will this increased size have on the environment? Task operation etc..
3. What steps can we take to prevent this in our Production Environment if this is a problem. (The Production TP DB is way more extensive - sitting at 66 GB - hence we want to prevent any mishaps)