CODEWITHSUNDEEP
sql-server
Jonas
Jonas

Reputation: 4584

Determine protocol of a given sql connection

I'm trying to see what connection protocol a given connection to sql 2008 is using (be it shared memory, named pipes, or tcp/ip)...I'm not seeing this info in the sql activity monitor. Is there some place I can view this?

Upvotes: 4

Views: 3544

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294237

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

select net_transport from sys.dm_exec_connections 
where session_id = @@spid

Upvotes: 10

Related Questions