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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy