• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 786
  • Last Modified:

sp_reset_connection

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

Regards,

Josh
0
jharwood
Asked:
jharwood
1 Solution
 
nigelrivettCommented:
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.
0
 
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!
0
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.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now