December 26, 2013

protocols used in current connection in sql server

To get details of protocols used in current connection in sql server you can execute following select query . You could know about Shared Memory,TCP/IP,Named Pipes,VIA (Virtual Interface Adaptor) on using below query.

SELECT session_id,connection_id, connect_time, net_transport, net_packet_size, client_net_address
FROM sys.dm_exec_connections

No comments:

Post a Comment