Export (0) Print
Expand All
Expand Minimize

sys.dm_exec_connections (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see sys.dm_exec_connections (Transact-SQL).

Returns information about the connections established to Microsoft Microsoft Azure SQL Database. The following table demonstrates the supported columns in Microsoft Azure SQL Database.

 

Column name Data type Description

session_id

int

Identifies the session associated with this connection. Is nullable.

most_recent_session_id

int

Represents the session ID for the most recent request associated with this connection. Is nullable.

connect_time

datetime

The timestamp when connection was established. Is not nullable.

net_transport

nvarchar(40)

Describes the physical transport protocol that is used by this connection. Is not nullable.

protocol_type

nvarchar(40)

Specifies the protocol type of the payload. Is nullable.

protocol_version

int

The version of the data access protocol associated with this connection. Is nullable.

endpoint_id

int

An identifier that describes what type of connection it is. Is nullable.

encrypt_option

nvarchar(40)

A Boolean value to describe whether encryption is enabled for this connection. Is not nullable.

auth_scheme

nvarchar(40)

Specifies the authentication scheme used with this connection. Is not nullable.

node_affinity

smallint

Identifies the memory node to which this connection has affinity. Is not nullable.

num_reads

int

The number of packet reads that have occurred over this connection. Is nullable.

num_writes

int

The number of data packet writes that have occurred over this connection. Is nullable.

last_read

datetime

The timestamp when the last read occurred over this connection. Is nullable.

last_write

datetime

The timestamp when the last write occurred over this connection. Not Is nullable.

net_packet_size

int

The network packet size used for information and data transfer. Is nullable.

client_net_address

varchar(48)

Host address of the client connecting to this server.

noteNote
In Microsoft Azure SQL Database, this column always returns NULL.

client_tcp_port

int

Port number on the client computer that is associated with this connection.

noteNote
In Microsoft Azure SQL Database, this column always returns NULL.

local_net_address

varchar(48)

Represents the IP address on the server that this connection targeted.

noteNote
In Microsoft Azure SQL Database, this column always returns NULL.

local_tcp_port

int

Represents the server TCP port that this connection targeted if it were a connection using the TCP transport.

noteNote
In Microsoft Azure SQL Database, this column always returns NULL.

connection_id

uniqueidentifier

Identifies each connection uniquely. Is not nullable.

parent_connection_id

uniqueidentifier

Identifies the primary connection. Is nullable.

most_recent_sql_handle

varbinary(64)

The SQL handle of the last request executed on this connection. The most_recent_sql_handle column is always in sync with the most_recent_session_id column. Is nullable.

Requires VIEW DATABASE STATE permission on server. Cannot be queried from the master database.

For more information about the sys.dm_exec_connections system view, see sys.dm_exec_connections (Transact-SQL) in SQL Server Books Online.

Community Additions

ADD
Show:
© 2014 Microsoft