When I run sp_who2 active, sp_reset_connection is always either dormant or runnable. This is an extended stored procedure, but I cannot find any information on it. I have been having cpu and response time problems lately and when I run the sp_who, it's there as dormant, but holding cpu. I kill it, and the system returns to normal. The isn't any obvious locking/blocking occuring. I am running sql2k on win2k in an active/passive cluster with dual 733's on both servers and 2gb of ram. My avg usage during peak is 30% so I am usually well under limits. Any information would be appreciated. Thanks


Who is Participating?
nigelrivettConnect With a Mentor Commented:
This is used for remote sp calls in a transaction. Don't know if that helps.

Maybe you have something wrong with a linked server for which it is trying to reset the connection.
jharwoodAuthor Commented:
Thanks nigel!
It turns out that the culprit is a trigger on a linkedserver which (Cringe!) has two cursors in it and fires a couple of sp's remotely!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.