SQL server

Find the network protocol used by a connection (spid).

There are a couple of protocols that can be used for connecting to a SQL server. Shared memory, TCP/IP, Named pipes, VIA namely. To find what protocol is used for a connection use the script: SELECT net_transport FROM sys.dm_exec_connections WHERE session_id = @@SPID; Replace @@SPID with another spid to check that connection. When on the local SQL server, the shared memory protocol is used if it is enabled, but this can be disabled to troubleshoot the other protocols. To see all the connections and the protocols currently being used, use: SELECT session_id,net_transport FROM sys.dm_exec_connections.


Thinking about someting? Leave a Reply...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s