[急] SQL Server 2005: Timeout Expired

knockyo

大家好，

I have a .net application that run at the production 24hrs.

1st case:
When i run the application around 2 days, next day i walk in to the production, i noticed that my application is "Out of responding". After that I closed all the application and tried to manual insert/update into the database server, it prompt me the picture below.

2nd case:
When I tried it on the next day again, my application available to grab the data and no more "Out of responding". I started the application from 10am, until 1pm my all application happened the same issue "Out of responding" and the database display the error below again.



**Question**
May I know my program/coding problem or the database server issue?

Kindly help me on these.

谢谢大家帮帮忙！

mokth

1. check u server performance, it very busy? Infected by virus ?some virus/trojan will fully occupied u network bandwidth.

2. U can prolong the timeout setting.

3. Check u sql script, it that too complicated ?

That all i can think.

knockyo

If the database LOG file is too huge, will affect timeout expired?