Results 1 to 6 of 6
  1. #1
    Join Date
    May 2002
    Location
    Brisbane, Australia
    Posts
    13

    Unanswered: CPU Time? what is it sec, milli-sec?

    when you run sp_who2, what is the numbers under CPUTime represent??
    Second, milliseconds? or something else

  2. #2
    Join Date
    Aug 2002
    Location
    UK
    Posts
    87
    the CPU time is taken from the sysprocesses table, and the cpu column is defined as :-

    Cumulative CPU time for the process. The entry is updated for all processes, regardless of whether the SET STATISTICS TIME ON option is ON or OFF.

    not that this answers you question, but thats all i know ....

  3. #3
    Join Date
    Aug 2002
    Location
    india
    Posts
    41
    nano second ie 1/1,00,000,0000

  4. #4
    Join Date
    Sep 2002
    Location
    MI
    Posts
    19
    60
    Jon Nelson

  5. #5
    Join Date
    May 2004
    Posts
    1

    CPU Time is in Milliseconds

    A Microsoft KB article (Q170360) that I found confirms that CPU time from sysprocesses (which is where sp_who2 gets its data) is in milliseconds.

  6. #6
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    nano second ie 1/1,00,000,0000

    lol That would be interesting.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •