Important DMVs for Database Mirroring...

Below are few important DMVs for Database mirroring....


select * from sys.dm_db_mirroring_connections
select connection_id,* from sys.dm_exec_connections
select * from sys.database_mirroring
select * from sys.database_mirroring_endpoints
select * from sys.database_mirroring_witnesses