Can the SQL Server Abnormal Mirroring Status be configured not to care about the mirroring having a witness? I do not configure my mirrors to the DR site to Auto Fail-over. So the alert returns continuous issues.
You may want to create a custom alert using this SQL. Then you can tweak it and even take the witness server references out.
SELECT
d.name + ' - Mirroring State Desc:' + m.mirroring_state_desc COLLATE DATABASE_DEFAULT + ' Mirroring Witness State Desc:' + m.mirroring_witness_state_desc COLLATE DATABASE_DEFAULT as Name,
1 as Value
FROM msdb.sys.database_mirroring m JOIN sys.databases d
ON m.database_id = d.database_id
WHERE (m.mirroring_state_desc IS NOT NULL AND m.mirroring_state_desc <> 'SYNCHRONIZED' )
OR (m.mirroring_witness_name IS NOT NULL AND m.mirroring_witness_name <> '' AND m.mirroring_witness_state_desc <> 'CONNECTED' )
Set it up as a multiple numeric custom alert, Configure it for the monitored database, with a threshold in the high min box of 1.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.