Auto shrink is on

How can we help?
< All Topics
Print

Auto shrink is on

In general, it is recommended to not have auto shrink on for any database, as it creates index fragmentation.

To query the Performance Store database for databases where auto shrink is on, use:

select d.*
from dbo.v_databases d
where d.is_auto_shrink_on = 1

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents