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.

Suggested Action

šŸ’” 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

Further Reading

Considerations for the "autogrow" and "autoshrink" settings in SQL Server | Microsoft Support

Turn AUTO_SHRINK off!! | SQL Server Database Engine Blog