Server unreachable

If PerformanceStore for some reason can not contact the server or the SQL Server service, a “server unreachable” alert will be send. I.e. if the Windows registry on the server is unreachable, but the SQL Server service is running, the “Server unreachable” alert will still be send.

To query the Performance Store database for servers that were previously discovered that are no longer discovered, use:

select s.*
from dbo.v_servers s
where s.discovered = 0
order by s.sample_time desc

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.