Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
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.