sp_Who2_cputime is 0 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sp_Who2_cputime is 0

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 ?
You should use:
sp_who2 active

it still shows the active process with CPUTime 0. Howver, i was able to find only spids less that 50 which is supposed to be system processes. Is there anything prob with appln or anything. Any idea .. ?Thanks..

You are write. Below spid 50 belong to system.
You should find CPU time in Spid > 50.
Check http://sqlserverplanet.com/dba/using-sp_who2/ for more information.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |