Skip to main content
How can we help?
< All Topics
Print

Wrong mirroring endpoint owner

When creating a mirroring endpoint, the default owner of the mirroring endpoint will be the person creating it. If that person leaves the company and the AD account is disabled, working with the mirroring endpoint can cause problems. It is advised to set the mirroring endpoint owner to the sa account.

To query the Performance Store database for wrong mirroring endpoint owners, use:

select s.*
from dbo.v_servers s
where s.mirroring_endpoint_owner_sid != 0x01

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.

Table of Contents