Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Just curious, per BOL

Wait Time (ms/sec) is the wait time in milliseconds for all tasks waiting for one or more resources in the category since last update.

Average Waiter Count is the number of tasks waiting.

Is it a coincidence that on my server Average Waiter Count is always Wait Time / 1000 rounded to nearest 10th? Is there a link here that makes it so? Am I going to be embarrassed when the answer is extremely logical but for some reason escaping me at the moment?

i.e here are sample values from the last 15 minutes for latch but other wait categories are the same (when any values exist) - I've noticed it for quite some time (much longer than last 15 mins) it just never piqued my interest enough to investigate until now.

Wait Time         Average Waiter Count
______________________________________
576               0.6
1403              1.4
1856              1.9
1233              1.2
1365              1.4

It just seems to me that since wait time is a cumulative count and waiters is an average the numbers shouldn't follow a ratio of each other as tightly as they appear.

share|improve this question
    
Curious, not something I've noticed before. Will check a couple of servers tomorrow and see if any similarity. –  Mark Storey-Smith Sep 7 '11 at 19:34
add comment

1 Answer

up vote 1 down vote accepted

I think a task is considered waiting if it is waiting for a whole second -- 1000ms. So if wait time for 1 second is 2000ms that means that 2 tasks where waiting in that second.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.