difference between session and task - sys.dm_db_session_space_usage/sys.dm_db_task_space

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » difference between session and task -...

difference between session and task - sys.dm_db_session_space_usage/sys.dm_db_task_space_usage

Rate Topic

Display Mode

Topic Options

Author

Message

curious_sqldba

Posted Friday, November 02, 2012 2:32 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 4:13 PM
Points: 1,172, Visits: 2,687

can someone please tell me what is the difference between session and task ?

Post #1380590

curious_sqldba

Posted Monday, November 05, 2012 9:32 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 4:13 PM
Points: 1,172, Visits: 2,687

anyone?

Post #1381163

jeetsingh.cs

Posted Monday, November 05, 2012 10:12 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:06 PM
Points: 179, Visits: 380

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

GilaMonster

Posted Monday, November 05, 2012 10:35 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 37,730, Visits: 29,996

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 »

Permissions