What does the elapsed time mean?

SQL Server parse and compile time:
   CPU time = 0 ms, elapsed time = 21 ms.

What does the elapsed time mean?
Mr_ShawAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
it means that the process took 21 milliseconds to complete, with 0 (rounded) ms where on CPU.
means that almost "all the time" the process had to wait for the CPU ...
0
 
Aaron ShiloConnect With a Mentor Chief Database ArchitectCommented:
hi

this means the time it took sql server to Parse And Compile The query
before executing it.
0
 
Mr_ShawAuthor Commented:
when the cpu = 0  deos it mean that the query was not recompiled.

If yes.... did it take 21ms to establish no recompile is needed?
0
 
Aaron ShiloConnect With a Mentor Chief Database ArchitectCommented:
Mr Shaw

dont forget that a soft Parse does take time eaven if the query wasent recompiled.

and yes if cpu is 0 then the query was probably not recompiled, eaven thow it is possible that the value was lower and rounded down.
0
 
Mr_ShawAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.