Skip to main content
How can we help?
< All Topics
Print

Unused databases

Databases are marked as unused if there has been no activity in the database for 90 days (default value that can be changed in the Performance Store Control Center).

For details more details see: Automated database cleanup.

To query the Performance Store database for databases with no activity for at least 90 days, use:

select *
from dbo.v_unused_databases_info d
where d.days_inactive > 90

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