MSSQL Connections

Check

SELECT net_transport

  FROM sys.dm_exec_connections

 WHERE session_id = @@SPID;

Possible return values...
  • Shared memory

Bibliography