• And does anyone know why sometimes I see more than one row for a particular SPID. For example I have one now that has 9 rows for one SPID. All I remember is that it has something to do with threads and/or paralelism, but I am pretty sure that server does not have 9 processors.

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems