Mark Johns (8/25/2009)
I am looking for the definition of a session and connections in SQL 2005? I have looked in the SQL 2005 BOL.
Can anybody help?
A connection represents the external connection to the server (over a network or locally through shared memory for example).
A session represents a user process within SQL Server.
A connection may be associated with zero, one, or many sessions.
Take a look at the columns on sys.dm_exec_connections and sys.dm_exec_sessions. That should give you a feel for the differences.