I am confused about the
connection_id column of
SELECT connection_id FROM sys.dm_exec_connections;
If I connect to an instance of SQL Server using SSMS, should it be one physical connection only? And multiple
New Query windows would represent different sessions represented by different
In particular, why does the result set of the above query return an different
uniqueidentifier for each session (and sessions that do seem to be currently open) of this same server connection?
Is this connection the same as the physical connection to an instance of SQL Server?