Is it OK to shrink SQL database?

Question

Precautions. If you want to shrink the reserved space of the database after you delete data and the reserved space needs to be increased later as data is inserted again, then this procedure may create physical disk fragmentation and affect performance. Be sure to run a disk defragmentation afterwards. 4 июн. 2021 г.

Is it safe to shrink a SQL database?

This is true that shrinking a database is not recommended. You can understand it like this when you shrink the database then it leads to increase in fragmentation now to reduce the fragmentation you try to rebuilt the index which will eventually lead to increase in your database size.

Does shrinking a SQL database improve performance?

Shrinking the database to a minimum required and releasing most of the unused space is possible. This may be a positive move as the larger freed space will improve performance. But shrinking may affect your database performance significantly, if not properly done.

Is Shrinking database good?

SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance.

Does shrink database affect performance?

Myth #9: Data file shrink does not affect performance. The only time a data file shrink won't affect performance is if you use the WITH TRUNCATEONLY option and there's free space at the end of file being shrunk. Shrink affects performance while it's running.

Expert · Answer