December 19, 2001 at 10:22 am
My processors on one server are avg 85+ utilization. I am in the process of trouble shooting this through profiler and perf mon. I have the traced data and was wandering if anyone knows what duration is in reference to time is it seconds? So if I have a query that has 10 for durations does that mean the sql engine processed that query in 10 seconds?
In addition, what I am seeing are connects and disconnects utlizing cpu the most, not queries. Any thoughts, suggestions onhow to improve this?
-JG
December 19, 2001 at 10:36 am
duration is milliseconds
from BOL:
Duration 13 Amount of time (in milliseconds) taken by the event.
Steve Jones
December 19, 2001 at 11:11 am
I looked all through BOL. What did you search on? Thanks for the info.
-JG
December 19, 2001 at 11:24 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply