Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sp_reset_connection

Posted on 2001-06-26
2
Medium Priority
?
763 Views
Last Modified: 2008-02-01
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
Comment
Question by:jharwood
2 Comments
 
LVL 18

Accepted Solution

by:
nigelrivett earned 300 total points
ID: 6230640
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
 

Author Comment

by:jharwood
ID: 6231479
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question