Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I was getting timeout error while executing a stored procedure from the web application. But this stored procedure is executing within a second while running from SQL management studio. This issue can happen when database's statistics and/query plan cache are incorrect. This can be resolved by updating statistics by executing exec sp_updatestats Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Solution: exec sp_updatestats If issue didn't resolve even after executing above this, you may need to optimize the query.