SQL Server Abnormal Mirroring Status

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.

Thanks I will give it a try.  We just got the software and I am trying to get it setup for my needs.

Awesome!  Welcome to the family.  8 )

For more detailed assistance, feel free to reach out to support via your customer portal also.

This is great in this one example I now know how to setup just about an type of custom alert.

Custom alerts and metrics are my favorite.  I can integrate any scripts I use personally into the product.

Have you checked out the Thwack content also?

Database Performance Analyzer