连接超时。在后登录阶段的超时时间已过 [英] 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屋!