DMV session statuses

  • I run query

    select

    r.session_id, r.status, s.status ,s.is_user_process

    from sys.dm_exec_sessions s

    join sys.dm_exec_requests r

    on r.session_id = s.session_id

    where

    s.is_user_process = 1

    result was

    session_idstatusstatusis_user_process

    507suspendedrunning1

    466runnablerunning1

    445runningsleeping1

    433runnablerunning1

    398runningrunning1

    310runningrunning1

    289suspendedrunning1

    279runningrunning1

    225runningrunning1

    52suspendedrunning1

    How session could be suspended in one DMV and running in another or running and sleeping ?

Viewing 0 posts

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