Skip to main content
Older versions of Internet Explorer will not support certain site features. Chrome, Safari, Firefox, and Edge will provide the best experience.
Spok

Monitoring SQL Mirroring

Monitoring SQL mirroring is an important step for configuring SQL Server redundant mirroring sessions.

You can check the status of mirroring, endpoints, certificates, and users with the following query:

select * from sys.database_mirroring
select * from sys.database_mirroring_endpoints
select * from sys.tcp_endpoints
select * from sys.certificates
select * from sys.database_principals

You can also check the state of the database mirroring by performing the following steps:

  1. Open SQL Server Management Studio.

  2. Connect to the principal server.

  3. Right click on the mirrored database to display menu options.

  4. Choose the Tasks > Launch Database Mirroring Monitor menu option. The Database Mirroring Monitor appears, showing the status of the database that is being monitored.