Auto Shrink Enabled
The auto shrink option is enabled, which will cause SQL Server to actively shrink data files, leading to performance issues and file fragmentation.
If there is an issue with ballooning database files, the cause of the undesired growth should be addressed. Routinely shrinking the database, automatically or manually, will only mask the problem while continuing to cause performance issues and skew capacity planning forecasts.
💡 Aireforge Advisor can automatically generate a script for this.
Auto shrink should be disabled, and the cause of any undesired growth addressed.
How to Disable Auto Shrink for a Database
USE [master] GO ALTER DATABASE [WhippetWorks] SET AUTO_SHRINK OFF WITH NO_WAIT; GO
Considerations for the "autogrow" and "autoshrink" settings in SQL Server | Microsoft Support
Turn AUTO_SHRINK off!! | SQL Server Database Engine Blog