When this option is enabled, SQL Server periodically shrinks the database and releases unused free space from the files to the OS.

But in case of first INSERT database tries to extend depending on growth size you had implemented. Than again shrinks because of auto-shrink. So it is better not to set this parameter for a database.


No responses yet

Bir cevap yazın

E-posta hesabınız yayımlanmayacak.