问题描述
我为我们公司创建了一个内部网站.它顺利运行了几个月，然后由于用户的建议，我进行了重大更新.当我在现场运行时，它运行正常.然后突然我的一位日本用户向我发送了等待操作超时".错误.当我检查访问该特定链接时，它会为我和其他一些我要求检查他们是否访问该页面的人正常运行.我已经更新了 httpRuntime executionTimeout 但仍然没有运气.错误来自数据库连接吗?如果我增加数据库连接的超时时间，它会解决问题吗?
I created an internal website for our company. It run smoothly for several months and then I made a major update due to user suggestion. When I run in live, it run normally. Then suddenly one of my user from japan sending me an "The Wait operation timed out." error. When I check access that certain link, It run normally for me and some other who I ask to check if they access that page. I already update the httpRuntime executionTimeout but still no luck. Is it the error come from database connection? If I increase the timeout in the database connection it will be fix the problem?
推荐答案
如果您发现确切的错误等待操作超时"，那么很可能您的数据库调用花费的时间比预期的要长.这可能是由于多种原因造成的:
If you found the exact error "The wait operation timed out" then it is likely you have a database call that took longer than expected. This could be due to any number of things:
- 瞬态网络问题
- 高 SQL 服务器负载
- SAN、RAID 或存储设备存在问题
- 死锁或其他形式的多进程争用
您没有分享足够的信息来进行故障排除.我处理这个问题的方法是检查问题的其他情况并查看是否存在模式，例如如果问题发生在一天中的某个时间.
You haven't shared enough information to troubleshoot. The way I would manage this would be to check for other occurrences of the problem and see if there is a pattern, e.g. if the problem occurs at a certain time of day.
当然，增加超时不是一个坏主意(如果它当前设置得非常低)，并且可以解决问题本身.
Certainly increasing the timeout is not a bad idea (if it is currently set pretty low) and may resolve the problem in and of itself.
这篇关于等待操作超时.ASP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！