Sysprocesses Table - Will It Help Me Debug Connection Pooling Issues?

I've got a windows service that regulary (every 10 sec) does a lot of db activity. I've verified that all my connections are closed (using using). After some time (days or hours) I

Solution 1:

sysprocesses is deprecated so if you're on 2005+ use sys.dm_exec_requests, sys.dm_exec_connections and sys.dm_exec_session.

that'll give you better info about your connections.