There are six methods are available for monitoring the Database Mirroring

a) Database Mirroring Monitor:- Database Mirroring Monitor is a GUI tool that shows update status and to configure warning thresholds.

To open DM Monitor:- Right click on Principal Database > Tasks > Select Launch Database Mirroring Monitor.

b) SQL Server Management Studio:- A green arrow on the mirror server is indicates running well. A red arrow indicates problems that need to investigate.

c) SQL Server Log:- It provides information of Mirroring establishment and status. If any errors occur it will be logged to SQL Server log and Windows event log.

d) Performance Monitor:- It can provides real-time information about Database mirroring. We can use performance counters to get status of the database mirroring such as Bytes received/sec, Bytes sent/sec, Transaction delay etc.

e) Profiler:- Profiler many events are providing the status of the Database mirroring

f) System Stored Procedures:-

sp_dbmmonitoraddmonitoring

sp_dbmmonitorchangemonitoring

sp_dbmmonitorhelpmonitoring

sp_dbmmonitordropmonitoring