Matching up columns from sysprocesses to DMV's

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  June 17, 2008 at 5:57 am

  #122815

  Hey all,

  I am having some issues with updating my who view ... I am getting rid of my sys.sysprocesses query in favor of the DMV's (sys.dm_exec_connections, sys.dm_exec_requests, sys.dm_exec_sessions). I have been able to match up everything except for dbid and command. While sys.dm_exec_requests does have the command and database_id columns, sys.dm_exec_requests is only based on currently executing requests. I find it hard to believe that sys.sysprocesses would contain data that the DMV's do not. So basically the problem I'm having is that some processes (usually idle system processes) will not return the database_id nor command.

  Am I missing something here? Is there another DMV I should be querying?

  Thanks

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  June 17, 2008 at 8:57 am

  #829853

  For the time being I'm using sys.sysprocesses ... but I'd really like to find an alternative.

  Thanks

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  June 17, 2008 at 2:21 pm

  #830049

  Well ... haven't had much luck ... anyone got something I'm missing here?

  Thanks

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  June 18, 2008 at 10:05 am

  #830601

  One more bump ... hopefully someone has had this issue ...

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  June 20, 2008 at 7:56 am

  #831774

  AH! I know this has to be possible ...