Hi.
I have NLB three-node IIS cluster under Windows 2003 + SP1.
I specify ODBC logging to remote SQL database (SQL 2000 EE). Now we try
analyze data and see strange records

Very simple query to DB:
select top 100 * from dbo.IIS_WebLog order by processingtime desc

In the log table I see parameter [processingTime] is like 5182235 or 4881485
milliseconds!!! It's > 1.26 hour! From IE I don't see SUCH delays.
What's happend? Can somebody describe it?

Thanks.

Re: IIS ODBC logiing by Burtsev

Burtsev
Tue Jun 27 08:58:46 CDT 2006

Some remarks.
Site has ASP and ISAPI extension.
HTTP status codes for this querys are 200, 500, 401.


"Burtsev Dmitry" <burtsev@remove.km.ru> wrote in message
news:%23y4eC5emGHA.4700@TK2MSFTNGP05.phx.gbl...
> Hi.
> I have NLB three-node IIS cluster under Windows 2003 + SP1.
> I specify ODBC logging to remote SQL database (SQL 2000 EE). Now we try
> analyze data and see strange records
>
> Very simple query to DB:
> select top 100 * from dbo.IIS_WebLog order by processingtime desc
>
> In the log table I see parameter [processingTime] is like 5182235 or
> 4881485 milliseconds!!! It's > 1.26 hour! From IE I don't see SUCH delays.
> What's happend? Can somebody describe it?
>
> Thanks.
>