How can we help?
Non-existing default database for user
If a user is having a default database set, but this database does not exist anymore, this alert will be thrown.
To query the Performance Store database for users where the default database does not exist, use:
select s.* from dbo.security s left join dbo.v_databases d on d.server_name = s.server_name and d.database_name = s.default_database and d.state_desc = 'ONLINE' where d.server_name is null and s.default_database is not null
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.