ASP Script Timed Out Errors and Slow Response Times

dman

dman

Perch
Hello,

I'm having issues with a site that uses ASP. Specifically, displaying results on this from an Access DB. This site was just moved from another Hsphere host and did not have these issues and I have not changed the code. It seems that there are performance issues with ASP.

The error I am getting is Script Timed Out, ASP 0113. I have looked through the forums and it tried increasing the time out period programmatically but this does not seem to be helping. Again, this was not an issue at the other host. Is there anything else I can do? Can you put this and another site in separate application pools? Any other suggestions? Am I crazy to think this should work at Jodo? If I can't resolve this, I will have to move my sites again or loose this business. Anybody having the issues as well or know a fix?

Also, I am getting crazy seek times with tracert to this site. You can see below that there is one returning 920 ms times and multiple 200+ ms times. I am in CA but these results seem to indicate issues at the data center. Anybody else have these issues?



1 * * * Request timed out.
2 5 ms 5 ms 5 ms 10.32.64.1
3 7 ms 7 ms 5 ms GIG2-1.HNBHCA1-RTR2.socal.rr.com [24.30.161.13]

4 6 ms 5 ms 5 ms SRP1-0.GDGVCA1-GSR1.socal.rr.com [24.30.161.129]

5 8 ms 21 ms 8 ms SO-1-1-0.LSANCA1-RTR1.socal.rr.com [66.75.161.17
4]
6 9 ms 8 ms 8 ms te-3-4.car2.LosAngeles1.Level3.net [4.71.36.105]

7 9 ms 11 ms 19 ms ae-31-53.ebr1.LosAngeles1.Level3.net [4.68.102.9
4]
8 16 ms 17 ms 18 ms ae-1-100.ebr2.LosAngeles1.Level3.net [4.69.132.6
]
9 45 ms 49 ms 49 ms ae-3.ebr3.Dallas1.Level3.net [4.69.132.78]
10 45 ms 55 ms 53 ms ae-78.ebr2.Dallas1.Level3.net [4.69.135.5]
11 68 ms 67 ms 71 ms ae-7.ebr3.Atlanta2.Level3.net [4.69.134.22]
12 64 ms 72 ms 71 ms ae-78.ebr2.Atlanta2.Level3.net [4.69.134.53]
13 74 ms 73 ms 74 ms ae-4-4.car2.Miami1.Level3.net [4.69.133.9]
14 245 ms 204 ms 106 ms ae-11-11.car1.Miami1.Level3.net [4.69.133.5]
15 73 ms 76 ms 74 ms INTERNAP-NE.car1.Miami1.Level3.net [4.79.100.46]

16 73 ms 74 ms 74 ms border5.pc1.bbnet1.mia003.pnap.net [69.25.0.13]

17 920 ms 97 ms * webhosting-9.border5.mia003.pnap.net [216.52.162
.66]
18 75 ms 74 ms 75 ms rtr1.m****here.biz [204.10.104.77]
19 76 ms 77 ms 78 ms domain.com [64.187.xxx.xxx]
 
That isn't at the datacenter, it is at the Level3 router however(level3 has their own datacenter here, some blocks away from where it connects to InterNAP). As for the Access Db submit a ticket and they will move it to an isolated pool to try it out.
 
Stephen said:
That isn't at the datacenter, it is at the Level3 router however. As for the Access Db submit a ticket and they will move it to an isolated pool to try it out.
Click to expand...

Hey Stephan, thanks for the quick reply. I have submitted a ticket as well and I'm waiting for a response. I had no problem at my previous Hsphere host but they may have given it an isolated pool as well. I am closing all my objects and connections as well so I shouldn't be causing Access max concurrent connection issues. With the isolated pool, if it helps, will they just leave it there or is there something else that needs to be done? This seems to be an issue with all the Access DBs on several sites. I really need to resolve this soon as this issue directly relates to incoming orders and effects the clients bottom line.
 
We can leave it in own pool, but ultimately I will tell you that SQL is the final answer :)
 
Good news. After submitting a support ticket, the Jodo rep increased the script time out and changed some other settings. All seems to be working fine now. I believe the issue is solved. Thanks for all the help and quick responses.
 
I have moved these sites over to MS SQL and I am still getting this error daily. They were also put in seperate application pools but these seem to expire. Here's the error:

Error Number: -2147012894
Error Description: The operation timed out

Any other ideas on how to resolve this issue? Does anyone know why this error is generated? This is happening on the following code on the Send line:


Set objXMLHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP.3.0")
lResolve = 10 * 1000
lConnect = 10 * 1000
lSend = 15 * 1000
lReceive = 15 * 1000
objXMLHTTP.setTimeouts lResolve, lConnect, lSend, lReceive
objXMLHTTP.Open method, page, false
objXMLHTTP.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
objXMLHTTP.setRequestHeader "User-Agent", Request.ServerVariables("http_user_agent")
' objXMLHTTP.setRequestHeader "Referrer", referer
objXMLHTTP.setRequestHeader "ACCEPT-LANGUAGE", "en-us"

objXMLHTTP.Send strPost
 
You must log in or register to reply here.
Back
Top