SA user with default name

It is advised to rename the sa user, so the default name is not “sa”.

To query the Performance Store database for servers where the SA user has not been renamed, use:

select s.*
from dbo.v_server_security s
inner join dbo.v_servers v on v.server_name = s.server_name
where s.is_sa = 1
and s.name = 'sa'

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.