13.10.09

Remote query timeout in SQL Server


Ocassionally, Application will throw Query timeout errors. Do we have analysed why its happening?



Remote query timeout is due to the following reasons,


1. Server performance is too slow due to large number of transactions. So, it couldn't allocate necessary resources for the current session.


2. Network issue.

3. May be a very long complex query which will take more time to execute.

In that case, we can set the option of remote query timout to infinite or we can increase the timings.




Cheers,
Venkatesan Prabu .J

No comments:

Post a Comment