Welcome to HostingForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

IIS hanging after cancelling page with long SQL query

  
   Web Hosting Problem Solving Community! (Home) -> IIS RSS
Next:  Redirection  
Author Message
astreeter_no_s

External


Since: Oct 08, 2003
Posts: 2



(Msg. 1) Posted: Wed Oct 08, 2003 8:26 pm
Post subject: IIS hanging after cancelling page with long SQL query
Archived from groups: microsoft>public>inetserver>iis (more info?)
I'm running IIS 5.1 on my Windows XP Pro development machine. The ASP page
I am working on locally uses VBScript with ADO to get a bunch of data via
SQL queries from a SQL Server 2000 server that is on a remote web host. The
web host sometimes is very slow, so then the queries take a really long time
and sometimes get time out errors. If the page does display, it can take up
to 2 minutes.

Now if I get tired of waiting for the page to load and hit the cancel button
in my browser, my IIS server effectively hangs for what seems to be close to
the remaining time that the SQL query would have taken to run if I had let
it finish. Even if I just type in "localhost" it takes a couple of minutes
for anything to appear in my browser. And if I start the page and cancel it
a bunch of times successively, it seems like the wait times add up, so if I
do that 5 times in a row, I have to wait 10 minutes before localhost returns
anything.

Stopping and restarting IIS service from the IIS MMC during the wait doesn't
seem to help either. The only thing I have found that does help if I don't
want to wait is to reboot the whole computer.

Is this really a problem with my IIS? Am I missing something?

 >> Stay informed about: IIS hanging after cancelling page with long SQL query 
Back to top
Login to vote
someone9

External


Since: Aug 25, 2003
Posts: 2419



(Msg. 2) Posted: Wed Oct 08, 2003 8:48 pm
Post subject: Re: IIS hanging after cancelling page with long SQL query [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hmm... if restarting IIS doesn't seem to help, then it really isn't IIS that
is "hanging" at all... Sounds like the problem is with the page itself and
not IIS's execution of the page.

I'm not an expert with ADO, but I suspect you can write your ASP code to be
more hang-tolerent by changing some query settings.

--
//David
IIS
This posting is provided "AS IS" with no warranties, and confers no rights.
//
"Alden Streeter" <astreeter_no_spam_.DeleteThis@srca.net> wrote in message
news:eqb3vsejDHA.2244@TK2MSFTNGP12.phx.gbl...
I'm running IIS 5.1 on my Windows XP Pro development machine. The ASP page
I am working on locally uses VBScript with ADO to get a bunch of data via
SQL queries from a SQL Server 2000 server that is on a remote web host. The
web host sometimes is very slow, so then the queries take a really long time
and sometimes get time out errors. If the page does display, it can take up
to 2 minutes.

Now if I get tired of waiting for the page to load and hit the cancel button
in my browser, my IIS server effectively hangs for what seems to be close to
the remaining time that the SQL query would have taken to run if I had let
it finish. Even if I just type in "localhost" it takes a couple of minutes
for anything to appear in my browser. And if I start the page and cancel it
a bunch of times successively, it seems like the wait times add up, so if I
do that 5 times in a row, I have to wait 10 minutes before localhost returns
anything.

Stopping and restarting IIS service from the IIS MMC during the wait doesn't
seem to help either. The only thing I have found that does help if I don't
want to wait is to reboot the whole computer.

Is this really a problem with my IIS? Am I missing something?

 >> Stay informed about: IIS hanging after cancelling page with long SQL query 
Back to top
Login to vote
qbernard

External


Since: Sep 05, 2003
Posts: 407



(Msg. 3) Posted: Thu Oct 09, 2003 1:37 pm
Post subject: Re: IIS hanging after cancelling page with long SQL query [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
It is the Sql query that dragging the slowness.
when you hit cancel, I believe the same 'cancel'
was issued to SQL as well. so SQL might try to
terminal the long running query.. say roll back or
cancelling the actual request.

all this take 'time' depend on your query, your
machine spec, db size and etc. while this is
running, web server just wait - you should
try to look at the cpu utilization, track down
which process is using the most cpu and ram.

all new request will be queue up in asp queue.

you can try stop and start the sql, it should release
back the web server to you.

--
Regards,
Bernard Cheah
<a style='text-decoration: underline;' href="http://support.microsoft.com/" target="_blank">http://support.microsoft.com/</a>
Please respond to newsgroups only ...



"Alden Streeter" <astreeter_no_spam_ DeleteThis @srca.net> wrote in message
news:eqb3vsejDHA.2244@TK2MSFTNGP12.phx.gbl...
 > I'm running IIS 5.1 on my Windows XP Pro development machine. The ASP
page
 > I am working on locally uses VBScript with ADO to get a bunch of data via
 > SQL queries from a SQL Server 2000 server that is on a remote web host.
The
 > web host sometimes is very slow, so then the queries take a really long
time
 > and sometimes get time out errors. If the page does display, it can take
up
 > to 2 minutes.
 >
 > Now if I get tired of waiting for the page to load and hit the cancel
button
 > in my browser, my IIS server effectively hangs for what seems to be close
to
 > the remaining time that the SQL query would have taken to run if I had let
 > it finish. Even if I just type in "localhost" it takes a couple of
minutes
 > for anything to appear in my browser. And if I start the page and cancel
it
 > a bunch of times successively, it seems like the wait times add up, so if
I
 > do that 5 times in a row, I have to wait 10 minutes before localhost
returns
 > anything.
 >
 > Stopping and restarting IIS service from the IIS MMC during the wait
doesn't
 > seem to help either. The only thing I have found that does help if I
don't
 > want to wait is to reboot the whole computer.
 >
 > Is this really a problem with my IIS? Am I missing something?
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: IIS hanging after cancelling page with long SQL query 
Back to top
Login to vote
kenremove

External


Since: Aug 23, 2003
Posts: 3041



(Msg. 4) Posted: Thu Oct 09, 2003 3:31 pm
Post subject: Re: IIS hanging after cancelling page with long SQL query [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Just because you hit "cancel" in the browser doesn't mean that IIS will stop
the query.

All you are doing is telling your browser not to bother with loading the
page. The browser isn't telling IIS that it doesn't want the data anymore...

What you can do is use:

Response.IsClientConnected()

in your ASP page to test to see whether the client browser is still
connected to the IIS server, and if not, call Response.End() which stops
processing of the ASP page.

Cheers
Ken


"Alden Streeter" <astreeter_no_spam_.RemoveThis@srca.net> wrote in message
news:eqb3vsejDHA.2244@TK2MSFTNGP12.phx.gbl...
: I'm running IIS 5.1 on my Windows XP Pro development machine. The ASP
page
: I am working on locally uses VBScript with ADO to get a bunch of data via
: SQL queries from a SQL Server 2000 server that is on a remote web host.
The
: web host sometimes is very slow, so then the queries take a really long
time
: and sometimes get time out errors. If the page does display, it can take
up
: to 2 minutes.
:
: Now if I get tired of waiting for the page to load and hit the cancel
button
: in my browser, my IIS server effectively hangs for what seems to be close
to
: the remaining time that the SQL query would have taken to run if I had let
: it finish. Even if I just type in "localhost" it takes a couple of
minutes
: for anything to appear in my browser. And if I start the page and cancel
it
: a bunch of times successively, it seems like the wait times add up, so if
I
: do that 5 times in a row, I have to wait 10 minutes before localhost
returns
: anything.
:
: Stopping and restarting IIS service from the IIS MMC during the wait
doesn't
: seem to help either. The only thing I have found that does help if I
don't
: want to wait is to reboot the whole computer.
:
: Is this really a problem with my IIS? Am I missing something?
:
:
 >> Stay informed about: IIS hanging after cancelling page with long SQL query 
Back to top
Login to vote
astreeter_no_s

External


Since: Oct 08, 2003
Posts: 2



(Msg. 5) Posted: Thu Oct 09, 2003 3:31 pm
Post subject: Re: IIS hanging after cancelling page with long SQL query [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thanks! That worked after I remembered to set Response.Buffer = True first
as well.

"Ken Schaefer" <kenREMOVE.DeleteThis@THISadOpenStatic.com> wrote in message
news:e1z9%231gjDHA.2312@TK2MSFTNGP12.phx.gbl...
 > Just because you hit "cancel" in the browser doesn't mean that IIS will
stop
 > the query.
 >
 > All you are doing is telling your browser not to bother with loading the
 > page. The browser isn't telling IIS that it doesn't want the data
anymore...
 >
 > What you can do is use:
 >
 > Response.IsClientConnected()
 >
 > in your ASP page to test to see whether the client browser is still
 > connected to the IIS server, and if not, call Response.End() which stops
 > processing of the ASP page.
 >
 > Cheers
 > Ken
 >
 >
 > "Alden Streeter" <astreeter_no_spam_.DeleteThis@srca.net> wrote in message
 > news:eqb3vsejDHA.2244@TK2MSFTNGP12.phx.gbl...
 > : I'm running IIS 5.1 on my Windows XP Pro development machine. The ASP
 > page
 > : I am working on locally uses VBScript with ADO to get a bunch of data
via
 > : SQL queries from a SQL Server 2000 server that is on a remote web host.
 > The
 > : web host sometimes is very slow, so then the queries take a really long
 > time
 > : and sometimes get time out errors. If the page does display, it can
take
 > up
 > : to 2 minutes.
 > :
 > : Now if I get tired of waiting for the page to load and hit the cancel
 > button
 > : in my browser, my IIS server effectively hangs for what seems to be
close
 > to
 > : the remaining time that the SQL query would have taken to run if I had
let
 > : it finish. Even if I just type in "localhost" it takes a couple of
 > minutes
 > : for anything to appear in my browser. And if I start the page and
cancel
 > it
 > : a bunch of times successively, it seems like the wait times add up, so
if
 > I
 > : do that 5 times in a row, I have to wait 10 minutes before localhost
 > returns
 > : anything.
 > :
 > : Stopping and restarting IIS service from the IIS MMC during the wait
 > doesn't
 > : seem to help either. The only thing I have found that does help if I
 > don't
 > : want to wait is to reboot the whole computer.
 > :
 > : Is this really a problem with my IIS? Am I missing something?
 > :
 > :
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: IIS hanging after cancelling page with long SQL query 
Back to top
Login to vote
Display posts from previous:   
   Web Hosting Problem Solving Community! (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]