Auto Shrink Enabled

When the auto shrink option is enabled, SQL Server will actively try to shrink data files, which can lead to fragmentation and performance problems.

Suggested Action

Auto shrink should be disabled for all databases.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.

Further Reading

Turn AUTO_SHRINK off!! | SQL Server Database Engine Blog