Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 768
  • 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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

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