user connections

[DLu]

Hi:

the sql perfomance monitor has user connections counter.
when I run select from sysprocess (SQL2000), the number is much larger than the user connections counter.

after put where dbID > 1 (I think it is 'User' connection) to exclude master db, the number is closing, but somewhat smaller than it, never match.

any idea?

thanks
David

[rmiao]

Don't count any process with spid < 51, they are system processes. By the way, each process may have multiple threads.

[DLu]

Hi Rmiao:
it matches now.
thanks
-D