Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Timeout on SQL Server
Message
From
18/04/2011 10:51:18
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01507700
Message ID:
01507712
Views:
29
>>When a timeout is returned on an update command, where should we go to obtain the related information as to know where this is configured? I have an update command that failed about 30 seconds and I am trying to find if this was related to entirely the SQL Server configuration.
>>
>>The exact message was:
>>
>>"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
>
>You can increase timeout in the config manager (in the connection string), but it may be also better to try to fine tune this update statement.

Connection timeout (which dictates how long ADO.NET will wait to establish a connection) is not the same as CommandTimeOut (which dictates how long it will wait for a query to complete)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform