Definition of Session and Connections

  • 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?

  • 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.

    Paul

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply