Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Definition of Session and Connections Expand / Collapse
Author
Message
Posted Tuesday, August 25, 2009 5:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 7:50 AM
Points: 1, Visits: 88
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?
Post #776561
Posted Tuesday, August 25, 2009 6:34 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, November 20, 2014 7:53 PM
Points: 9,928, Visits: 11,194
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




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #776601
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse