Hi Gail,

I ran this query

SELECT SD.NAME,SD.dbid,lastWaittype FROM SYSPROCESSES SP INNER JOIN

SYSDATABASES SD ON SD.DBID=SP.DBID WHERE SD.DBID=21

and with that database i got only two lastwaittype they are

MISCELLANEOUS and

PAGELATCH_UP

And the count is not taking any time not even a second.