Hi, We converted our sql server database to 14.0.3391.2, then we did a NAV upgrade from NAV 2016 to BC14/NAV 2018.
Now, our database size is increasing much faster than it did before.
In addition, our differential backup is increasing at 5 or 10 times the rate it did before.
Has anyone noted this condition?
Does BC14 tend to generate more transactions than previous versions of NAV?
Our business volume has not increased, so I am at a loss to explain this.
It might be the Change Log. Previous versions of NAV logged only changes made by users on Pages. But then Microsoft changed it so that even modifications made by code are logged now.
If you have the change log enabled on tables that are quite often used in your processes, the change log will grow rapidly.
You can use the following query to check the biggest tables in your database. I suggest running it periodically (once per week) and save the output in a separate table to see which tables are growing.