IIS Hangs on Update or Insert from ASP

[Mark]

I am having the following issue with IIS/ASP.

Setup:

Windows 2000
SQL Server 2000
IIS 5.0
(All running on same machine.)

For some reason, any ASP page that contains an Update or
Insert SQL query will cause IIS to hang. ASP pages are
still being served as well as ASP pages that use Select
queries to get data from the same database.

This behavior occurs when a form is submitted on a page
containing code to update or insert data into the
database. Once the *submit* button is pressed IE will
just sit there waiting for a reply. It will NOT time out
however.

If I stop my website (not IIS) and *unload* the web site
(via IIS admin) I am able to succussfully Insert and
Update in my application via ASP. After a random period
of time, the problem will occur again.

I am able to execute the same code successfully in
Enterpise Manager and Query Ananlyzer using the same SQL
account that is being used by my application.

Does anyone have any ideas as to what may be happening?

Thank you,

-- Mark

[Mark]

The server is an eight processor server w/ 1 gb of RAM.
The proc times are fine, no spikes or anything. Plus,
there is not a lot of traffic on this server, especially
considering how much power it has.

All of the connections are being cleared every time.

One thing I forgot to mention: any page that hangs with
the below conditions is not logged in the IIS log.

-- Mark

>-----Original Message-----
>Hi,
>
>Are you cleaning up all of your database connections

when

>you are finished with them? Is there excessive blocking
>on the SQL Server? Is the SQL Server particularly

busy?

>Perhaps the SQL Server does not have enough cpu to

manage

>the traffic it gets...
>
>Sincerely,
>Invotion Engineering Team
>Advanced Microsoft Hosting Solutions
>[url]http://www.Invotion.com[/url]
>

>>-----Original Message-----
>>I am having the following issue with IIS/ASP.
>>
>>Setup:
>>
>>Windows 2000
>>SQL Server 2000
>>IIS 5.0
>>(All running on same machine.)
>>
>>For some reason, any ASP page that contains an Update

or

>>Insert SQL query will cause IIS to hang. ASP pages are
>>still being served as well as ASP pages that use Select
>>queries to get data from the same database.
>>
>>This behavior occurs when a form is submitted on a page
>>containing code to update or insert data into the
>>database. Once the *submit* button is pressed IE will
>>just sit there waiting for a reply. It will NOT time

>out

>>however.
>>
>>If I stop my website (not IIS) and *unload* the web

site

>>(via IIS admin) I am able to succussfully Insert and
>>Update in my application via ASP. After a random

period

>>of time, the problem will occur again.
>>
>>I am able to execute the same code successfully in
>>Enterpise Manager and Query Ananlyzer using the same

SQL

>>account that is being used by my application.
>>
>>Does anyone have any ideas as to what may be happening?
>>
>>Thank you,
>>
>>-- Mark
>>.
>>

>.
>

[Mark Schupp]

Something to think about as a last resort:

We had a client last year on a quad-processor system who experienced
periodic hangs (which of course were blamed on our application). After
several months of debugging we were able to demonstrate that none of our
code was executing when the hangs occured. The client wiped the system and
reinstalled everything and the problem went away. I don't know if there were
any other indicators to point at an OS problem (not on very good terms with
that client, everytime they send us money the check bounces).

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


"Mark" <mkschultz4@hotmail.com> wrote in message
news:041901c3b079$e1c06680$a301280a@phx.gbl...

> The server is an eight processor server w/ 1 gb of RAM.
> The proc times are fine, no spikes or anything. Plus,
> there is not a lot of traffic on this server, especially
> considering how much power it has.
>
> All of the connections are being cleared every time.
>
> One thing I forgot to mention: any page that hangs with
> the below conditions is not logged in the IIS log.
>
> -- Mark
>

> >-----Original Message-----
> >Hi,
> >
> >Are you cleaning up all of your database connections

> when

> >you are finished with them? Is there excessive blocking
> >on the SQL Server? Is the SQL Server particularly

> busy?

> >Perhaps the SQL Server does not have enough cpu to

> manage

> >the traffic it gets...
> >
> >Sincerely,
> >Invotion Engineering Team
> >Advanced Microsoft Hosting Solutions
> >[url]http://www.Invotion.com[/url]
> >

> >>-----Original Message-----
> >>I am having the following issue with IIS/ASP.
> >>
> >>Setup:
> >>
> >>Windows 2000
> >>SQL Server 2000
> >>IIS 5.0
> >>(All running on same machine.)
> >>
> >>For some reason, any ASP page that contains an Update

> or

> >>Insert SQL query will cause IIS to hang. ASP pages are
> >>still being served as well as ASP pages that use Select
> >>queries to get data from the same database.
> >>
> >>This behavior occurs when a form is submitted on a page
> >>containing code to update or insert data into the
> >>database. Once the *submit* button is pressed IE will
> >>just sit there waiting for a reply. It will NOT time

> >out

> >>however.
> >>
> >>If I stop my website (not IIS) and *unload* the web

> site

> >>(via IIS admin) I am able to succussfully Insert and
> >>Update in my application via ASP. After a random

> period

> >>of time, the problem will occur again.
> >>
> >>I am able to execute the same code successfully in
> >>Enterpise Manager and Query Ananlyzer using the same

> SQL

> >>account that is being used by my application.
> >>
> >>Does anyone have any ideas as to what may be happening?
> >>
> >>Thank you,
> >>
> >>-- Mark
> >>.
> >>

> >.
> >