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.

Comments

Popular posts from this blog

മലയാളത്തില്‍ മൊത്തം എത്ര അക്ഷരങ്ങള്‍ ഉണ്ട്?

Crystal reports load report failed: Could not load file or assembly CrystalDecisions.Web, Version=10.2.3600.0

Convert Number To Words in SQL Sever