Important Query For DBA

Which protocol is being used for client-server connectivity in SQL Server?

SELECT net_transport FROM sys.dm_exec_connections WHERE session_id = @@SPID;

Above  query return our server  connection protocol. There are 4 protocol there for connect database server with client.

• Shared Memory
• TCP/IP
• Named Pipes
• VIA (Virtual Interface Adapter)