There are six methods are available for monitoring the Database Mirroring:

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.

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

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

Performance Monitor:- It can provide 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.

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

System Stored Procedures:-

• sp_dbmmonitorupdate monitoring
• sp_dbmmonitorchange monitoring
• sp_dbmmonitorhelpmonitoring
• sp_dbmmonitordropmonitoring

There are six methods are available for monitoring the Database Mirroring:

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.

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

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

Performance Monitor:- It can provide 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.

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

System Stored Procedures:-