All geek questions in one place

Define a protocol for a given sql connection

I am trying to see which connection protocol uses this connection for sql 2008 (be it shared memory, named pipes or tcp / ip) ... I do not see this information in the sql activity monitor. Is there a place where I can see this?

+3
source share
1 answer

sys.dm_exec_connections DMV has physical connection information, including the protocol used:

select net_transport from sys.dm_exec_connections 
where session_id = @@spid
+8
source

Source: https://habr.com/ru/post/1715475/

More articles:


All Articles