Your database
Performance
Security & compliance
Stability
SQL Server auto-shrink enabled
Part of the Schema & indexes check · fix arrives as a guide
What it is
SQL Server auto-shrink is enabled on the database.
Why it matters
Auto-shrink repeatedly releases and reclaims file space, and the shrink operation heavily fragments indexes as it moves pages. The database then spends effort re-growing the file it just shrank, which is why Microsoft advises against it.
How to fix it
Disable auto-shrink and size the data files for expected growth instead. If space needs reclaiming after a one-off deletion, shrink manually once and rebuild the indexes afterwards.
Run them all on your app
Connect your repo and your live services with read-only scopes. The first scan is free, and nothing changes without your approval.