Does anybody know how to view, manage, trace, or ananlyze worker threads in sql server 2000? I need to be able to tell what threads are currently running and what processes each thread belongs to. Is this handled by sql server or by windows?
Maybe not what you are looking for..In the "System monitor" you can view the threads running in SQLServer. Is your application running multiple threads in one process? If not, you can see all processes in Enterprise manager(under management/process info)