c# - 连接超时已过期。登录后阶段超时时间已过

Question

在我的应用程序中，查询工作正常。对于单个选择查询，我遇到以下错误。

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 来检测死锁，但没有发现。

我正在通过 Entity Framework 运行简单的查询

任何帮助将不胜感激

Answer 1

在堆栈溢出中，有一个名为 Help troubleshooting SqlException: Timeout expired on connection, in a non-load situation 的帖子.这是一个与您的问题非常相似的问题。请看一下。

我将引用(来自该帖子的)评论作为您问题的可能原因:

"Not Enough Memory"

"You may have 'Auto Close' enabled"

"SQL Agent Jobs may be causing problems"

在那篇文章中，您可以看到关于该主题的非常好的解释。