What is the reason behind the DB size got increased after Table Otimization?

Business Central/NAV Technical Forum
1

What is the reason behind the DB size got increased after Table Otimization? Database used size got reduced and Database size got increased.

2

Hi,

During optimization program reindexs the index and it increase the log file size this will cause the increase in DB.

3

To shrink the log afterward - if necessary - you should use a DBCC SHRINKFILE command (only on the Log) and not the “Shrink Database” option!

4

Personally I would NOT shrink the log file after a reindexing. You should do a reindex on a weekly basis, so it will autogrow to the bigger size anyway. If you continuously shrink and grow the log file, it can get fragmented, with severe performance problems as a result. The best thing you can do is find a stable size and just leave it alone.

5

So NAV Table Optimization will result the grows up of log file and database size, ryt? But the database used size will be got reduced after optimization. Is right?

6

If the database is growing (data or log) during an optimization (or any operation) then it doesn’t have enough free space.

7

Yep, the gowth is because you make changes (optimize indexes) thus the log increases.

g.