Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SP_WHO2 Question
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00800799
Message ID:
00800862
Views:
23
This message has been marked as the solution to the initial question of the thread.
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
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform