CODEWITHSUNDEEP
c#.netsql-server-2008visual-studio-2008ado.net
George2
George2

Reputation: 45771

how to quickly check communication protocol used by SQL Server

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?

Upvotes: 0

Views: 1749

Answers (1)

Stuart Ainsworth
Stuart Ainsworth

Reputation: 12940

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.

Upvotes: 4

Related Questions