开发者

sp_reset_connection taking a long time to run

开发者 https://www.devze.com 2023-01-24 01:05 出处:网络
I\'ve got an application where all the sproc开发者_开发问答s 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 an

I've got an application where all the sproc开发者_开发问答s 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!


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号