I believe that this values are pulled from the SYSPROCESSES table:
CPUTime - 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.
DiskIO - Cumulative disk reads and writes for the process.
LastBatch - Last time a client process executed a remote stored procedure call or an EXECUTE statement. For system processes, the time at which SQL Server startup occurred is stored.
From within the context of the Master database, you can use sp_helptext 'sp_who2' to get the source of the stored procedure.
-Mike
>This sp lists CPUTime and DiskIO and lastBatch. I was hoping someone could confirm I understand these values.
>
>I'm assuming that both the cputime and diskio represent time usage in Milliseconds, and that the LastBatch was the last datetime of the "statement" they performed?
>
>Also, to convert milliseconds to seconds do I just divide by 1000?
>
>Thanks
>Kirk