连接超时。在后登录阶段的超时时间已过 [英] Connection Timeout Expired. The timeout period elapsed during the post-login phase
问题描述
在我的应用程序，查询工作的罚款。 对于单个select查询，我收到以下错误。
In my application, queries are working fine. For a single select query, i am getting below error.
System.Data.EntityException：基础提供程序未能打开。 ---> System.Data.SqlClient.SqlException：在连接超时。在后登录阶段的超时时间已过。该 连接可能已超时等待服务器来完成 登录过程和响应;或者，它可能已超时，而 尝试创建多个活动连接。持续时间花 同时试图连接到这台服务器是 - [pre-登录] 初始化= 0;握手= 13914; [登录]初始化= 0; 认证= 0; [后登录]完整= 1062; ---> System.ComponentModel.Win32Exception：等待操作超时
System.Data.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=0; handshake=13914; [Login] initialization=0; authentication=0; [Post-Login] complete=1062; ---> System.ComponentModel.Win32Exception: The wait operation timed out
我已经跑sqlprofiler检测死锁，但没有找到。
I have ran sqlprofiler for detecting deadlocks but found none.
我通过实体框架运行简单查询
I am running simple query through entity framework
任何帮助将AP preciated
Any help would be appreciated
推荐答案
下面的堆栈溢出，有一个名为帮助排除故障SQLEXCEPTION交：超时已过期的连接，在无负荷情况。这是一个问题非常相似于您的问题。请大家看看。
Here in stack overflow, there is a post called Help troubleshooting SqlException: Timeout expired on connection, in a non-load situation. It is a problem very similar to your problem. Please take a look.
我要引用（从这个职位）评论为您的问题的一个可能的原因：
I will quote (from that post) a comment as a possible cause of your problem:
内存不足
你可能有自动关闭已启用
"You may have 'Auto Close' enabled"
SQL代理作业可能导致问题的
"SQL Agent Jobs may be causing problems"
在这个职位，你可以看到关于该主题的很好的解释。
In that post you can see a very good explanation about the topic.
这篇关于连接超时。在后登录阶段的超时时间已过的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
