SQL Server Performance Forum – Threads Archive
Transitioning to sys.dm_exec_requestsWe 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"?