Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-22 : 08:51:33
|
Brad writes "Is there any way to correlate the SPID in SQL Server to the corresponding thread ID shown in Performance Monitor?
When you go do the Performance Monitor and look under the Thread Object, there is a listing of many Instances, which appear to represent NT threads. Each instance for each process is assigned its own instance number. What I would like to know is how to correlate this instance number with the matching SPID.
The reason I would like this info is because I often have very busy threads (as indicated by Performance Monitor), and I want to find the SPID that represents this very busy thread so I can figure out what is going in with that particular user connection." |
|
|
|
|
|
Can You Correlate the SPID to the PM Thread ID?