Skip to main content

Posts

Showing posts with the label Shared Memory

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