May 26, 2003 at 8:10 pm
Hi,
I've got an ASP page making stored proc calls to a SQL Server 2000 db. When load testing, I keep getting timeout errors coming up, usually intermittently.
I've gone through my configuration settings in SQL, and have set my query timeouts to 240 seconds (using sp_configure). Check the Tools->Options->Advanced, and changed the settings to 240 just in case.
Checked IIS, set 240 on the ASP Timeout page as well.
In my ASP script (using ADO), set my connection timeout to 240 in there.
My timeouts are happening between 60-90 seconds in.
So what have I missed?
many thanks
May 26, 2003 at 8:36 pm
Seems I found the answer.
Although I set the timeout option for connection in ASP, you can also override the timeout option for commands to the SQL Server, which default at 30. Changed this, and all is sweet now.
cheers
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply