how to quickly check communication protocol used by SQL Server

Question

Hello everyone,

I am using VSTS 2008 + C# + ADO.Net + SQL Server 2008. When connecting from another remote machine, normally TCP/IP protocol is used by ADO.Net client to connect to SQL Server 2008. When connecting locally (ADO.Net client and SQL Server on the same machine), normally shared memory or named pipe is used.

My question is, besides the general rules, how to check exactly (e.g. from some SQL Server built-in commands/tools/store procedures?) what communication protocol is used by a specific connection?

thanks in advance, George

Answer 1

This is new to me, but you could try using the dynamic management views:

SELECT *
FROM sys.dm_exec_connections dec

gives a lot of information about connections.

HTH, Stu