We have a IIS 6.0 server connected to a SQL Server 2000 Cluster that is
tracking click throughs. The problem is that for some reason for about 5
minutes, _randomly_, it stops it's connection to SQL Server. We have
extended the number of available ports and time outs. We are using
connection pooling and I have watched it while it happens and nothing seems
to jump out...CPU usage, memory usage, etc. on either box doesn't seem to be
significant at all. It's almost as if it is some kind of IIS bug.

Also, some times, with the same server and another we have in a load balance
network, some websites we create can have a delay response of 4-5 seconds on
plain static content when other pages that are ASP.NET can response 50 times
per second in the same load balance network. Has anyone experienced these
problems before?

Walter

Re: IIS 6.0 and SQL Server 2000 by Ken

Ken
Sat Dec 11 17:45:36 CST 2004

WRT to the first question, how are you getting the data into SQL Server?
ADO+OLEDB, or ADO.NET? etc

IIS itself can't connect to SQL Server - you need to use some kind of data
access technology, so I doubt it's a bug in IIS...

Cheers
Ken


"Walter Holm" <walt.holm@walterholm.net> wrote in message
news:eS6oHgv3EHA.2180@TK2MSFTNGP12.phx.gbl...
> We have a IIS 6.0 server connected to a SQL Server 2000 Cluster that is
> tracking click throughs. The problem is that for some reason for about 5
> minutes, _randomly_, it stops it's connection to SQL Server. We have
> extended the number of available ports and time outs. We are using
> connection pooling and I have watched it while it happens and nothing
> seems to jump out...CPU usage, memory usage, etc. on either box doesn't
> seem to be significant at all. It's almost as if it is some kind of IIS
> bug.
>
> Also, some times, with the same server and another we have in a load
> balance network, some websites we create can have a delay response of 4-5
> seconds on plain static content when other pages that are ASP.NET can
> response 50 times per second in the same load balance network. Has anyone
> experienced these problems before?
>
> Walter
>