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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-04-03 : 15:32:46
|
| When i do sp_who2 There is CPU Time and Disk I/O Is this what the particular process is doing at the time. CPU Time is this in milliseconds Disk I/O is this in bytes and to get to megs * by 1024If the process is just sleeping are these just taking up value cpu ?Thanks |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-04-04 : 10:38:21
|
| Those values are cumulative over the life of the connection. |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-04-04 : 11:09:22
|
| CPU time is measured in milliseconsand i/o measured in 8k ?Is there a way to get for each process. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
SP_WHO2