Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adjustment on the timeout
Message
De
14/03/2008 19:21:04
 
 
À
14/03/2008 19:03:33
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01302038
Message ID:
01302358
Vues:
9
This message has been marked as the solution to the initial question of the thread.
Silly question, but I like to rule everything out. What does this setting show? The same?

1. Open SQL Server Enterprise Manager and find the server that contains your database.
2. Right click on the server name.
3. Select properties.
4. Choose the Connections tab.
5. Increase the query timeout value. (The value is in seconds. Set it to 0 for unlimited time)
6. Click OK.

(Sorry I cut and paste)

>>Keep in mind that the default of 600 applies to an outgoing connection initiated by the Database Engine as a remote query. This value has no effect on queries received by the Database Engine.
>
>In our situation, the timeout happens from a hit coming from the Web. So, from the VB.NET code, executing a SQL select command could cause it. It is in regards to that that I would like to increase the timeout. For now, we have it at about 30 seconds, from what I can see. This is too low. I do recognize the fact that we need to redesign some of the issues we have. But, one thing for sure, at startup, on the first SQL select commands on big tables, it will take longer. I also have seen that behavior when we use VFP as the backend. It seems the tables are being cached on their first accesses and it performs faster for the ongoing ones.
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform