Returns one row for each task that is active in the instance of
SQL Server. Memory address of the object. State of the task.
This can be one of the following: PENDING: Waiting for a worker
thread. RUNNABLE: Runnable, but waiting to receive a quantum.
RUNNING: Currently running on the scheduler. SUSPENDED: Has a
worker, but is waiting for an event. SPINLOOP: Stuck in a
spinlock. Number of scheduler context switches that this task
has completed. Number of physical I/Os that are performed by
this task. Total byte count of I/Os that are performed by this
task. Average byte count of I/Os that are performed by this
task. ID of the parent scheduler. This is a handle to the
scheduler information for this task. For more information, see
sys.dm_os_schedulers (Transact-SQL). ID of the session that is
associated with the task. Execution context ID that is
associated with the task. ID of the request of the task. For
more information, see sys.dm_exec_requests (Transact-SQL).
Memory address of the worker that is running the