SQLServerCentral / Administering / SQL Server 2005 / difference between session and task - sys.dm_db_session_space_usage/sys.dm_db_task_space_usage / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 12:08:10 GMT20RE: difference between session and task - sys.dm_db_session_space_usage/sys.dm_db_task_space_usagehttp://www.sqlservercentral.com/Forums/Topic1380590-146-1.aspxTask is the currently running querySession is the total since the session (connection) logged in.Mon, 05 Nov 2012 22:35:16 GMTGilaMonsterRE: difference between session and task - sys.dm_db_session_space_usage/sys.dm_db_task_space_usagehttp://www.sqlservercentral.com/Forums/Topic1380590-146-1.aspxSESSIONSession 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.Mon, 05 Nov 2012 22:12:24 GMTjeetsingh.csRE: difference between session and task - sys.dm_db_session_space_usage/sys.dm_db_task_space_usagehttp://www.sqlservercentral.com/Forums/Topic1380590-146-1.aspxanyone?Mon, 05 Nov 2012 09:32:38 GMTcurious_sqldbadifference between session and task - sys.dm_db_session_space_usage/sys.dm_db_task_space_usagehttp://www.sqlservercentral.com/Forums/Topic1380590-146-1.aspxcan someone please tell me what is the difference between session and task ?Fri, 02 Nov 2012 14:32:01 GMTcurious_sqldba