Once the database mirroring is configured it is very important to monitor the performance of SQL Server and ldf size of the mirroring configured databases.network utilization of the Principle and Mirrored Server,you might get a question how many databases can be configured for log shipping, as per my experience 10 isĀ  the max value .

below are few important queries are used to monitor Mirroring environment

Query to know the state of Mirroring

select name as Endpoint ,state_desc from sys.database_mirroring_endpoints

Query to list Port’s related with Mirroring

select name,type_desc,port from sys.tcp_endpoints

Query to Know the Database Timeout in

select mirroring_connection_timeout from sys.database_mirroring

you can change the mirroring timeout of a database.

Leave a Reply

Your email address will not be published. Required fields are marked *