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 |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2008-11-12 : 08:15:50
|
Do any of you guys know how accurate the StartTime and EndTime clumns in SQL Profiler are? The reason I'm asking is that when monitoring activity in my database I see that I have i.e. 87 transactions happening in the 48th second in a minute, but then I don't see any more records until the 51st second. An example:14:07:48 -> 87 transactions14:07:49 -> nothing14:07:50 -> nothing14:07:51 -> 72 transactions This doesn't make sense and I would like to know how many transactions are going through every second. Are there any more accurate ways of meisuring this?- Lumbago |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-12 : 10:28:14
|
| You can check with transaction/sec counters in Perfmon. |
 |
|
|
|
|
|
Profiler - accuracy of "start/endtime"