how to solve The wait operation timed out Error

@Prabhu E

 

1. your first solution >> 1. If your SP having JOIN Queries without NOLOCK. Please feel free to use with (NOLOCK). >> but i am not using sp

 

your second solution>> If you already included CommandTimeout in DB call. Please increase it. >> but when data is increase in tables then what to do always increasing the CommandTimeout ???

 

Third solution >> i already increased the time 120 seconds to 240 seconds but it is not solved yet

 

so please tell me what is the problem of timeout error

 

and solution

Thanks in advance

Hello,

 

Try to do the below steps. Hope this will help you.

 

1. If your SP having JOIN Queries without NOLOCK. Please feel free to use with (NOLOCK).

 

2.  If you already included CommandTimeout in DB call. Please increase it. 

 

3. If the above two methods not helped means, try to increase the timeout at IIS level.

hi,

 

 Please make sure that your SQL server is accesible by the application.

Also check if you application pool is running or not.

 

https://stackoverflow.com/questions/36909490/the-wait-operation-timed-out

 

https://forums.asp.net/t/2017100.aspx?The+wait+operation+timed+out+in+SQL+Server

 

Hope this helps