November 8, 2011 at 8:35 am
Q. How do you prevent an application from timing out? the application itself dev in c++, C# and Or VB. the language is not relevant, what is relevant is that the application is timing out, before it gets to SQL Server.
is there any way we can fix that issue or detect that from SQL.
I think I know the answer, but I would like a third point of view.
:w00t:
"We never plan to Fail, We just fail to plan":)
November 8, 2011 at 8:42 am
The default Remote Query TimeOut is 600 seconds. You can modify this setting by going to server properties and click connection.
November 8, 2011 at 8:42 am
How did you make sure it doesn't even reach sql server?
The standard answer is to tune the queries so they run faster.
November 8, 2011 at 8:44 am
I don't think the timeout is happening where you think it is. You are getting a connection timeout? That means that your sql is taking longer to complete than the timeout duration established for your connection. There are two things you can do.
1) Make your sql faster.
2) Increase the timeout length.
By far the most desirable is #1. In .net the default connection timeout is 30 seconds which can be too short for some really complex things but usually be enough time. If your sql is too slow there are mountains of things you can do to improve it.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply