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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-02-24 : 17:34:38
|
| I'm puzzled by something I am seeing in profiler. I have one trace configured to profile the following events where Duration >= 1000.SP:StmtCompletedSP:CompletedSQL:BatchCompletedRPC:CompletedSQL:StmtCompletedI'm capturing EndTime, HostName, LoginName, CPU, Reads, Writes and TextData, plus a two or three other bits of information. When the trace runs I can see a number of stored procedures and SQL statements completing in over 5 seconds.If I create another trace which includes the corresponding SP, SQL and RPC ...Starting Events, where Duration is > 0 and run it at the same time as the above trace, I rarely see a duration > 1 second.I can look at the same command on both profiler sessions and see different durations. Why is this happening?Thanks, Dave |
|
|
|
|
|
Capturing Duration in Profiler