The hostess slate, shown in a DMV called sys.dm_os_waiting_tasks, contains currently suspended sessions and reasons as regards the denial including the session_id, wait_type and the session’s accumulated recess every so often as regards this recess classification in the column wait_duration_ms. -Sys.dm_exec_requestsEach SQL Server sitting has a unexcelled session_id in the combination DMV sys.dm_exec_requests. The stored combination sp_who2 provides a slate of these sessions in putting together to other interplay gen such as bidding, resource, recess types, recess every so often, and reputation. exceptionally User queries see fit drink a session_id > 50. exceptionally A sitting reputation of ‘Sleeping’ indicates SQL Server is waiting as regards the next SQL Server bidding. exceptionally Common reputation values are ‘running’, ‘runnable’ and ’suspended’, as described in the Execution Model talk. – Sys.dm_os_waiting_tasksThe hostess slate that shows all waiting sessions and the reasons as regards the waits can be establish in the DMV sys.dm_os_waiting_tasks.
The session_id, recess classification, and associated recess every so often can be seen. exceptionally In putting together, if the sitting is blocked from acquiring a engage, the sitting holding (known as blocking) the engage as rise as the blocked resource is shown in the columns blocking_session_id and resource.