sys.dm_db_mirroring_connections
Returns a row for each connection established for database mirroring.
| Column name | Data type | Description |
|---|---|---|
connection_id |
uniqueidentifier |
Identifier of the connection. |
transport_stream_id |
uniqueidentifier |
Identifier of the SQL Native Interface (SNI) connection used by this connection for TCP/IP communications. |
state |
smallint |
Current state of the connection. Possible values: 1 = NEW 2 = CONNECTING 3 = CONNECTED 4 = LOGGED_IN 5 = CLOSED |
state_desc |
nvarchar(60) |
Current state of the connection. Possible values: NEW CONNECTING CONNECTED LOGGED_IN CLOSED |
connect_time |
datetime |
Date and time at which the connection was opened. |
login_time |
datetime |
Date and time at which login for the connection succeeded. |
authentication_method |
nvarchar(128) |
Name of the Windows Authentication method, such as NTLM or KERBEROS. The value comes from Windows. |
principal_name |
nvarchar(128) |
Name of the login that was validated for connection permissions. For Windows Authentication, this value is the remote user name. For certificate authentication, this value is the certificate owner. |
remote_user_name |
nvarchar(128) |
Name of the peer user from the other database that is used by Windows Authentication. |
last_activity_time |
datetime |
Date and time at which the connection was last used to send or receive information. |
is_accept |
bit |
Indicates whether the connection originated on the remote side. 1 = The connection is a request accepted from the remote instance. 0 = The connection was started by the local instance. |
login_state |
smallint |
State of the login process for this connection. Possible values: 0 = Initial 1 = Negotiate 2 = SSPI 3 = PublicKeyLogin 4 = PublicKeyTentative 5 = LoggedIn 6 = Arbitration |
login_state_desc |
nvarchar(60) |
Current state of login from the remote computer. Possible values: Initial Negotiate SSPI PublicKeyLogin PublicKeyTentative Arbitration LoggedIn |
peer_certificate_id |
int |
The local object ID of the certificate used by the remote instance for authentication. The owner of this certificate must have CONNECT permissions to the database mirroring endpoint. |
receives_posted |
smallint |
Number of asynchronous network receives that have not yet completed for this connection. |
is_receive_flow_controlled |
bit |
Whether network receives have been postponed due to flow control because the network is busy. 1 = True |
sends_posted |
smallint |
The number of asynchronous network sends that have not yet completed for this connection. |
is_send_flow_controlled |
bit |
Whether network sends have been postponed due to network flow control because the network is busy. 1 = True |
total_bytes_sent |
bigint |
Total number of bytes sent by this connection. |
total_bytes_received |
bigint |
Total number of bytes received by this connection. |
total_fragments_sent |
bigint |
Total number of database mirroring message fragments sent by this connection. |
total_fragments_received |
bigint |
Total number of database mirroring message fragments received by this connection. |
total_sends |
bigint |
Total number of network send requests issued by this connection. |
total_receives |
bigint |
Total number of network receive requests issued by this connection. |
encalg |
smallint |
Encryption algorithm used for this connection. Possible values: 1 = No Encryption 2 = RC4 3 = AES |
Permissions
Requires VIEW SERVER STATE permission on the server.
See Also
Reference
Dynamic Management Views and Functions