Post reply

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

  • November 2, 2012 at 2:32 pm

    #264988

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

  • November 5, 2012 at 9:32 am

    #1556120

    anyone?

  • November 5, 2012 at 10:12 pm

    #1556292

    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.

  • November 5, 2012 at 10:35 pm

    #1556295

    Task is the currently running query

    Session is the total since the session (connection) logged in.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

Viewing 4 posts - 1 through 3 (of 3 total)

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