
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?
David