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.
| Author |
Topic |
|
kbk
Starting Member
34 Posts |
 Posted - 2009-01-28 : 15:42:31
|
| In this query,is cpu time in microseconds and what is total elapsed time?SELECT sqltext.TEXT,req.session_id,req.status,req.command,req.cpu_time,req.total_elapsed_timeFROM sys.dm_exec_requests reqCROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext Thankyoubk |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2009-01-28 : 16:05:36
|
| Hmmm..This was easily found (its the first hit on google).Go here.[url]http://technet.microsoft.com/en-us/library/ms177648.aspx[/url]r&r |
 |
|
|
|
|
|
query