Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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