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

difference between session and task - sys.dm_db_session_space_usage/sys.dm_db_task_space_usage Expand / Collapse
Author
Message
Posted Friday, November 02, 2012 2:32 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:44 PM
Points: 1,266, Visits: 2,912

can someone please tell me what is the difference between session and task ?
Post #1380590
Posted Monday, November 05, 2012 9:32 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:44 PM
Points: 1,266, Visits: 2,912
anyone?
Post #1381163
Posted Monday, November 05, 2012 10:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:27 AM
Points: 251, Visits: 540
SESSION

Session tells the server, how to fetch the metadata from repository for the specified mapping (data flow).


TASK

Task is a particular work that is for eg. Assignment Task is used to assign a value to the variable for the entire workflow.
Post #1381368
Posted Monday, November 05, 2012 10:35 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:56 AM
Points: 41,559, Visits: 34,486
Task is the currently running query
Session is the total since the session (connection) logged in.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1381371
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse