Post reply

Confusion on average wait time counter

  • September 25, 2007 at 11:38 am

    #118678

    I've been monitoring one of our production servers and have not been able to get a full grasp on the average wait time counter under perf mon. I know it is in milliseconds, and there are 100 milliseconds in one second. But, I set up perf mon to grab this info in 15 second intervals and the numbers show up to a 10 second average wait time. This throws me off...especially because the intervals a few seconds both before and after that one did not show any wait time.

    Here are some numbers...

    9/24/2007 10:32:59 AM69517.67

    9/24/2007 10:33:14 AM0.00

    9/24/2007 10:33:29 AM0.00

    9/24/2007 10:33:44 AM0.00

    9/24/2007 10:33:59 AM2.07

    9/24/2007 10:34:14 AM65.61

    9/24/2007 10:34:29 AM4.13

    9/24/2007 10:34:44 AM0.00

    9/24/2007 10:34:59 AM2.07

    9/24/2007 10:35:14 AM64235.68

    9/24/2007 10:35:29 AM0.00

    9/24/2007 10:35:44 AM4.13

    9/24/2007 10:35:59 AM0.00

    9/24/2007 10:36:14 AM51.07

    9/24/2007 10:36:29 AM0.00

    9/24/2007 10:36:44 AM2316.71

    9/24/2007 10:36:59 AM0.00

    9/24/2007 10:37:14 AM52882.97

    9/24/2007 10:37:29 AM4.07

    9/24/2007 10:37:44 AM8307.33

    Is anyone able to explain this better for me / have any suggestions?

    Thanks!

  • September 26, 2007 at 9:50 am

    #736432

    There are 1000 milliseconds in a second, but even with that, it looks odd. How many CPUs do you have?

    Are these lock waits? What's the full object and counter name?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply