Home Forums SQL Server 2005 Administering difference between session and task - sys.dm_db_session_space_usage/sys.dm_db_task_space_usage RE: difference between session and task - sys.dm_db_session_space_usage/sys.dm_db_task_space_usage
jeetsingh.cs
SSCommitted
Points: 1741
More actions
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.