Wednesday, March 7, 2012

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

when you run sp_who2, what is the numbers under CPUTime represent??
Second, milliseconds? or something elsethe 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 ...|||nano second ie 1/1,00,000,0000|||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.|||nano second ie 1/1,00,000,0000

lol That would be interesting.

No comments:

Post a Comment