Script to Monitor Mirroring
This script will provide all database which is mirrored with mirroring mode, mirroring status and partner information.
SELECT Sd.Name AS Databasename, Mirroring_state_desc AS Status, CASE WHEN Mirroring_safety_level = 1 THEN 'High Performance' WHEN Mirroring_safety_level = 2 THEN 'High Safety' ELSE NULL END AS Mirroringmod, Mirroring_role_desc, Mirroring_partner_instance FROM MSDB.SYS.Database_mirroring Sdm JOIN MASTER.SYS.Sysdatabases Sd ON Sdm.Database_id = Sd.Dbid WHERE Mirroring_guid IS NOT NULL
Regards,
Nirav Gajjar