ASP page hangs

[MikeG]

Running IIS 6.0 on Server 2003 (no SP 1 yet)
When calling an ASP from within a Perl script to perform a query against a
web-enabled database (don't ask how we arrived at this architecture), the
first query almost always times out with an Timer_EntityBody error. Our
timeout is currently set at 300 seconds. We can see that the worker thread
(we only have one for compatibility purposes) gets kicked off when the query
arrives. Successive queries do not time out. Has anyone had any experience
with this type of issue? What did you do to troubleshoot it? Did applying
SP 1 help?

Thanks in advance.

 

[Larry Bud]

Running IIS 6.0 on Server 2003 (no SP 1 yet)
When calling an ASP from within a Perl script to perform a query against a
web-enabled database (don't ask how we arrived at this architecture), the
first query almost always times out with an Timer_EntityBody error. Our
timeout is currently set at 300 seconds. We can see that the worker thread
(we only have one for compatibility purposes) gets kicked off when the query
arrives. Successive queries do not time out. Has anyone had any experience
with this type of issue? What did you do to troubleshoot it? Did applying
SP 1 help?

I would run the ASP by itself, bypassing your Perl script (PLEASE tell
me how you arrived at this!!), and printing out the SQL in the browser.
Then you can see if yoru SQL truly is the same each time your Perl
script runs. YOu can also pu the SQL in Query Analyzer to see what
you're missing.