Post reply

sysprocesses vs DMV's and parallel execution

  • July 2, 2008 at 1:32 pm

    #123065

    Why is it that none the three replacement DMV's to sysprocesses will display multiple threads if an execution is parallelized?

    For example, I'm doing a restore right now ...

    select * from sys.sysprocesses where spid = 61

    - 5 sessions, each with different resource utilization's

    select * from sys.dm_exec_sessions where session_id = 61

    - 1 session

    select * from sys.dm_exec_requests where session_id = 61

    - 1 request

    select * from sys.dm_exec_connections where session_id = 61

    - 1 connection

    This on top of an earlier discussion (Matching up columns from sysprocesses to...) in which I've yet to resolve ... has me wondering why at this point I'd want to bother with the replacement of sysprocesses with DMV's when sysprocess hasn't been fully replaced.

    Am I missing something glaringly obvious here?

    This is all in attempts to fix my who view I've been working on ... sometimes I just get way to many threads of a spid if it has a parallel execution (see attached).

    Thanks

  • July 3, 2008 at 6:23 am

    #837769

    Any assistance would be much appreciated.

    Thanks

  • July 3, 2008 at 1:13 pm

    #838095

    I think you need to also query some other dmvs - sys.dm_os_tasks, sys.dm_os_workers, sys.dm_os_threads etc., depending on what level of detail you are looking to obtain. Tasks is a good one to start with as it has columns for session and request ids.

Viewing 3 posts - 1 through 2 (of 2 total)

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