Endpoint

Endpoint: An endpoint is a SQL Server object that enables SQL Server to communicate over the network. It encapsulates a transport protocol and a port number.

An endpoint is a network protocol which is used to communicate Principal, Mirror and Witness servers over the network.

Creation of an end point:-

Create endpoint <endpoint name> State=started/stopped/disabled

as tcp (listener port=5022/5023) for database_mirroring (role=partner/witness)

Using Database Mirroring Monitor

We can monitor the following features
·         Unsent Log     (at principal)
·         Un restored Log (at mirror)
·         Transaction Rate
·         Commit Overhead (Transactions applied rate at mirror)

Automatic Failover Timeout .
ALTER DATABASE dbName SET PARTNER TIMEOUT 20 .

Failover -
ALTER DATABASE AdventureWorks SET PARTNER FAILOVER;