SQL Server 2005: Timeout Expired

[knockyo]

Hi all,

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.

Thanks very much!

Regards,
Gary

 

[cjard]

By default in the .NET native provider for sql server, queries are limited to 30 seconds and connection attempts must also complete within 30 seconds. Any query or connection taking longer than this, is cancelled. In one app I have that uses queries that take many minutes to complete I set the relevant timeout properties to 3600.

SqlCommand.CommandTimeout Property (System.Data.SqlClient)
SqlConnection.ConnectionTimeout Property (System.Data.SqlClient)