SQL Server Performance

Transitioning to sys.dm_exec_requests

Discussion in 'SQL Server 2005 General DBA Questions' started by rerichards, Aug 28, 2006.

  1. rerichards New Member

    We are nearing the time to migrate to SQL 2005 and am trying to transition from master..sysprocesses to sys.dm_exec_requests.

    When I run sys.dm_exec_requests on my DEV environment about 20 rows are returned. When I run sys.sysprocesses on the same environment I am returning about 80 rows. I guess I am confused on what is a "request" and what is a "process"?

    Intuitively, it would seem that a "request" is something that is actually doing something, yet I see in the Status column that some request's are "sleeping". So, how does a "request" differ from a "process"?

Share This Page