In my application, queries are working fine. For a single select query, i am getting below error.
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
I have ran sqlprofiler for detecting deadlocks but found none.
I am running simple query through entity framework
Any help would be appreciated
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:
"Not Enough Memory"
"You may have 'Auto Close' enabled"
"SQL Agent Jobs may be causing problems"
In that post you can see a very good explanation about the topic.