Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I frequently query sys.dm_exec_query_stats to find expensive queries. I've noticed that in some cases the total_worker_time is greater than the total_elapsed_time. Does anyone know why this would be the case? I'm looking at an example right now where the last_worker_time is greater than the last_elapsed_time.

Perhaps the worker time is the sum across multiple processors/cores?

share|improve this question
up vote 4 down vote accepted

It is indeed the sum of multiple processors' work. I'd bet dollars to donuts that if you look at the cached plan that you'll see some parallelism in it.

share|improve this answer
Yup, I did notice the parallelism included in the query plan. Thanks for confirming - I couldn't find any documentation regarding this. – Mario Aug 5 '11 at 14:30

Your Answer


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.