locked
Need help interpreting results of SET STATISTICS TIME ON RRS feed

  • Question

  • Hi,

     

    I used SET STATISTICS TIME ON to get execution stats for a query.  I found that the CPU Time was sometimes greater than the elapsed time.  How is this possible?  The query does not use any parallelism since I used the query option MAXDOP 1.  Is the elapsed time wait time?  Is the total execution time the sum of the CPU time and elapsed time?

     

    SQL Server Execution Times:

    CPU time = 797 ms, elapsed time = 162 ms.

    Friday, December 14, 2007 5:25 PM

Answers

  • Hi GeenanT
    You might be hitting this issue. http://support.microsoft.com/kb/931279/en-us I banged my head on the wall try to figure this out a while back..


    Friday, December 14, 2007 7:00 PM
    Answerer

All replies

  • Hi GeenanT
    You might be hitting this issue. http://support.microsoft.com/kb/931279/en-us I banged my head on the wall try to figure this out a while back..


    Friday, December 14, 2007 7:00 PM
    Answerer
  • Thanks, that appears to explain the issue - we are using servers with AMD Opteron processors that use power saving technology. 

     

    Friday, December 14, 2007 7:48 PM