IIS deteriorates

External Since: Nov 02, 2007 Posts: 1

Hi folks,

We have an occasional problem that occurs with IIS on our web server.

It doesn't happen very often but requires an IIS Reset when it does. IIS
response deteriorates but no errors written to logs. Symptoms are odd
because there's a collateral effect with a SQL Servers performance
deteriorating that doesn't make sense, as soon as as IISRESET is performed
SQL performance increases again.

The IIS crash / hang agent doesn't pick anything up as IIS doesn't actually
crash.

Has anybody come across this before?

Thanks

Paul

External Since: Jan 28, 2006 Posts: 170

"Paulo" <chewbacca.RemoveThis@wookie.org> wrote in message
news:Osn94$THIHA.6068@TK2MSFTNGP02.phx.gbl...
> Hi folks,
>
>
>
> We have an occasional problem that occurs with IIS on our web server.
>
>
>
> It doesn't happen very often but requires an IIS Reset when it does. IIS
> response deteriorates but no errors written to logs. Symptoms are odd
> because there's a collateral effect with a SQL Servers performance
> deteriorating that doesn't make sense, as soon as as IISRESET is performed
> SQL performance increases again.
>
>
>
> The IIS crash / hang agent doesn't pick anything up as IIS doesn't
actually
> crash.
>
>
>
> Has anybody come across this before?
>
>

ASP or ASP.NET?

If you have an number of ASP/ASP.NET pages waiting for large and/or
intensive SQL Server queries to complete you would be running out of worker
threads thereby slowing down the IIS server. When you IISRESET the threads
waiting for SQL results a killed, SQL detects this and discards the query
processes its running, hence you see corelation between IIS and SQL
performance.

--
Anthony Jones - MVP ASP/ASP.NET