Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 sp_who2 cpu s 0

Author  Topic 

reoaran
Starting Member

20 Posts

Posted - 2010-12-06 : 15:27:59
Hi...while checking for performance issues, i run sp_who2, i have more than 100 spids turning out and all of them are having a cputime of 0 (zero).SOme how it shold be a cumulative of cpu time. Others are normal. Can anyone let know why it is showing like that ?
   

- Advertisement -