Profiler Question About CPU/Duration on Disconnect Event 
Author Message
 Profiler Question About CPU/Duration on Disconnect Event

When I run profiler and watch the Disconnect events (EventClass = 15), they
show total CPU and Duration for the connection, among other things. I assume
that these values are both in milliseconds.

What I am finding is that it appears more CPU is used that the total
duration for the connection. For example, while the Duration column may
contain 63 (ms), the CPU contains 848,885 (ms).

If I am correct about the units of measure, how can a 63ms connection time
use 848,000 ms of CPU?

I've seen this occur on both SQL 7.0 and 2000 servers with this event.

Any ideas?


Tue, 09 Dec 2003 04:51:11 GMT
 [ 1 post ] 

 Relevant Pages 

1. Puzzler: CPU time < SQL Profiler Profiler duration

2. CPU and duration in profiler

3. SQL2K Profiler doesn't show duration for SP:recompile event

4. SQL Profiler "disconnect Event"

5. Profiler Question (Duration Discrepency)

6. SQL Profiler : duration and object_id questions

7. Profiler Event Question

8. Profiler does not pick up any data in duration column

9. duration, read differences in sql profiler and in server trace

10. Profiler doesn't show duration

11. Profiler is not showing duration

12. Duration is 0 in Profiler?

Powered by phpBB® Forum Software