dm_exec_connections


Columns

Column Type Size Nulls Auto Default Children Parents Comments
session_id int 4 √ null
most_recent_session_id int 4 √ null
connect_time datetime 16,3 null
net_transport nvarchar 80 null
protocol_type nvarchar 80 √ null
protocol_version int 4 √ null
endpoint_id int 4 √ null
encrypt_option nvarchar 80 null
auth_scheme nvarchar 80 null
node_affinity smallint 2 null
num_reads int 4 √ null
num_writes int 4 √ null
last_read datetime 16,3 √ null
last_write datetime 16,3 √ null
net_packet_size int 4 √ null
client_net_address nvarchar 96 √ null
client_tcp_port int 4 √ null
local_net_address nvarchar 96 √ null
local_tcp_port int 4 √ null
connection_id uniqueidentifier 16 null
parent_connection_id uniqueidentifier 16 √ null
most_recent_sql_handle varbinary 64 √ null

Relationships

Close relationships within degrees of separation