Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've got an application where all the sprocs are running nice and quick, but the sp_reset_connection calls between them are taking anything up to 20 seconds. I've looked at locking and blocking but can't see any happening and don't understand how this would effect sp_reset_connection. Help!

share|improve this question
Are you just now seeing this behavior or has it "always" been there? This link doesn't help anser your question but provides a nice list of what happens when the proc – jl. Nov 9 '10 at 17:54
Is it causing a problem? – gbn Nov 9 '10 at 18:02
It's causing a big problem since I'm using connection pool and the next time uses the connection it sites there and waits for this to complete. – Andrew Hancox Nov 10 '10 at 9:37
up vote 1 down vote accepted

I've figured out what the issue was. It looks like when you run a trace the data gets written as part of this sproc, this means that if you're tracing into a table and the insert speed isn't stellar everything grinds to a halt.

share|improve this answer
Can you expound on this? I'm not sure I understand your answer. – Holistic Developer Dec 20 '13 at 20:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.