jack sands
Old Hand
Points: 314
More actions
June 21, 2006 at 1:04 pm
#114025
Can anyone tell me when you do a sp_who2 is CPU time is measured in seconds or milliseconds?
Also does anyone have a query that can do what sp_who2 does but it shows the cpu time in H:M:S format?
Thanks.
Prakash Sawant
SSCrazy
Points: 2173
June 22, 2006 at 8:42 am
#645280
Try this...
sp_helptext sp_who2
------------Prakash Sawant
http://psawant.blogspot.com
sqldba-294117
Hall of Fame
Points: 3486
June 22, 2006 at 10:28 am
#645316
CPUTime is in miliseconds & DiskIO are in bytes. look this link for more info http://vyaskn.tripod.com/sp_who3.htm (thanks to Author Mike A. Barzilli)
i hope this will help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply