We are currently experiencing "timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding " error message occasionally when we are trying to extract the data from SQL DB through .NET application.
We are having application on different server and SQL DB is on different server. Application is using Connection string through .NET application configuration file and connecting to DB.
When we are running Update Statistics job in SQL DB, the timeout error is vanished and application is extracting data successfully.
All the time whenever timeout error is appearing, we need to run Update Statistics job.
Can anyone help is there anything we can fix not to run Update statistics job all the time whenever timeout occurred. Any alternative solution available?