The database is managed using MSSQL.
The database has a large capacity (about 300GB) and I want to compress the database every day, but I am not sure how to determine the design of "free space to leave after compression".

I would appreciate it if you could teach me the effects of setting the minimum 1%.

  • Answer # 1

    If you decrease the number, file fragmentation will occur more easily.
    If you want to compress every day, it is recommended that you leave a free space of about the amount that increases per day + α.