Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Performance Questions - dm_exec_requests

Author  Topic 

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2009-12-22 : 09:58:18
Here is my main question:

1. We have queries with for example, Elapsed Time: 4000, CPU Time: 20, Wait Time: 20. What is SQL Server doing with the other 3960 milliseconds?


Here are 2 other questions:

2. What does the Status 'suspended' mean?

3. Does Oracle have an equivalent to dm_exec_query_stats?
   

- Advertisement -