增加SQL连接超时性能影响
我看到经常出现的SQL连接超时问题。增加超时后，我再也看不到了。性能是否会增加超时？
I see frequent sql connection timeout issues. After increasing timeout, I don’t see that anymore. Is there any impact in the performance on increasing the timeout?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
连接超时与查询超时不同。增加连接超时设置不会影响查询性能，但是问题不会提及查询超时。这些查询都可能是“完美的”，但是由于网络问题，连接提供商超时等，连接请求可能会超时，否则由于SQL Server“侦听器”未及时响应，因此可能会定时出现。
如果增加连接超时对您有效，那就太好了！您可能只是一个慢网络。
玩得开心！
罗恩
Connection timeouts are not the same as query timeouts. Increasing the connection timeout setting does not affect query performance, but the question does not mention query timeouts. The queries could all be "perfect", but the connection request could timeout due to network issues, connection provider timeouts, etc. Or it could be timing out due to SQL Server "listener" not responding in time.
If increasing the connection timeout works for you, then great! It could be you just have a slow network.
Have Fun!
Ron