Hi,

This is possible, if there is no activity on the server, during the 3 seconds period when the sp_whocpu calculates the cpu_delta.

The spid that runs sp_whocpu is ignored.

None of the sleeping processes which do not consume cpu will show either, so it is possible that at a certain moment you don't get any output.

This is what differentiates sp_whocpu from sp_who2 for example. Running sp_who2 will show all processes, some with quite high cpu figures, when in fact they do not consume any resources at that moment in time.

Cheers,

Mircea