motioneye
asked on
sp_who2 and sys.dm_exec_requests return me difference rows
Hi,
In sql2005 I run sp_who2 and found bunch of rows with this sp then I try with DMV select * from sys.dm_exec_requests but it return me very less process, why?
so if sys.dm_exec_requests only return me less process as compare to sp_who2 what will be the benefit of using this DMV?
In sql2005 I run sp_who2 and found bunch of rows with this sp then I try with DMV select * from sys.dm_exec_requests but it return me very less process, why?
so if sys.dm_exec_requests only return me less process as compare to sp_who2 what will be the benefit of using this DMV?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.