Skip to main content
Planview Customer Success Center

Sometimes the database size increases, but a lot of it is unused space. Is this a defect?

This is not a defect. SQL Server often allocates temporary space that later is released without shrinking the database files. Some jobs, such as the reindexing job, allocate a lot of extra space.

There is no need to shrink the database, because SQL Server will reallocate any space it needs next time the jobs run. Also, SQL Server will reuse existing free space before extending the files further, which it cannot do if you shrink the database.