How can we help?
Non-existing databases in extended audit include
If a database has been included in the dbo.audit_extended_include table, but does not exist anymore, this alert will be thrown.
To query the Performance Store database for databases that do not exist, but are marked to be included in the extended audit functionality, use:
select a.* from dbo.audit_extended_include a left join dbo.databases d on d.server_name = a.server_name and d.database_name = a.database_name inner join dbo.servers s on s.server_name = a.server_name where d.server_name is null and a.database_name is not null and a.database_name not like '%[%]%'
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.