Non-existing databases in owner whitelist

One or more databases exists in the database owner whitelist table dbo.database_owner_whitelist, but the databases do not exist.

To query the Performance Store database for non-existing databases in the owner whitelist, use:

select a.server_name, a.database_name
from dbo.database_owner_whitelist 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
group by a.server_name, a.database_name

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.