Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
1  
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 runs..sqldev.net/articles/sp_reset_connection/default.html –  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 ado.net uses the connection it sites there and waits for this to complete. –  Andrew Hancox Nov 10 '10 at 9:37

1 Answer 1

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

 
discard

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.