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 |
|
imStuck
Starting Member
8 Posts |
 Posted - 2006-09-08 : 01:16:53
|
| Hi, when running a stack trace on my Sql server what is the duration measurement equivelant to in seconds? example query Duration=1670 what is this is seconds? 1.670 perhaps? And is the 'Reads' measurement a count of how many records were looked to satisfy the query? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-08 : 01:30:08
|
Duration is in milliseconds.Reads is not row count. According to BOL, it is:quote:
Number of logical disk reads performed by the server on behalf of the event.
Tara Kizer |
 |
|
|
imStuck
Starting Member
8 Posts |
Posted - 2006-09-08 : 01:31:34
|
| thanks for the speedy reply |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-09-08 : 03:12:31
|
| the read (and write) profiler stats are reported as the number of 8k blocks used. So a value of 40,000 means that the number of kbytes used equals 40000 * 8. The duration is in milliseconds and the CPU stats are also in milliseconds. This is for SQL 7 and 2K.My understanding is in SQL2K5 the duration stat is captured in microseconds instead of milliseconds. CPU and read/write are the same as before though.-ec |
|
|
|
|
|
|
SQL Profiler, trace duration