February 9, 2005 at 1:17 pm
I'm running a very long script in QA that does all differents tasks (inserts, updates etc). Every 10 min or so I get a time-out. What can I do about it? Please help...
February 9, 2005 at 3:17 pm
Make sure that Query time-out value in QA is set to 0 seconds. You can check this by:
Tools => Options => Connections => Query time-out (seconds) in QA.
Hope this helps.
February 10, 2005 at 7:29 am
Thank you for your advice, bit I tried it, didn't help... Actually, it's not a query, it's something with a server memory, I guess, it can't keep up the session long enough.
February 10, 2005 at 3:53 pm
Why don't you see if you can break down into smaller transactions?
February 12, 2005 at 8:27 am
There is an advanced parameter called query governor cost limit which you can set using sp_configure. The default value is 0 which means that however long the query is, it will execute. Make sure that this parameter does not have a non zero value.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply