Re: IISState log (IIS slow)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Janis Buks (JanisBuks_at_discussions.microsoft.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 01:19:03 -0800

Thank you for your reply. I would appriciate if you could help me to solve
this big trouble.

So this problem may be in asp code?

05 031c1ad4 11ce2a1c ODBC32!SQLFreeConnect+0x18
06 0c733a1d 00000000 0x11ce2a1c
May be this is ODBC problem releasing connection??

All queries is limited to max ~10000 row return.

Here is my story(from another unanswered post here):
IIS processes pages normally without errors(only IIS Log sometimes throws
ODBC object not found exception), but
with delays(sometimes long delays).

We have 2003 server system with MSSQL2k on it and asp/asp.net applications
running. Previously we had win2k and iis 5.0 and same trouble. IIS uses only
NT4 file security when client requests file.

We have monster 2*P4 machine with 2Gb of ram, Raid..etc..
AVG server load is 50-60% when IIS stops responding normally, asp&sql code I
think is optimised, but still there is lags when it
comes to opening asp files(even sometimes without asp code in it/plain html).

Two entrys I see in windows system log:

A lot of :

A worker process with process id of 'xxxx' serving application
pool 'DefaultAppPool' has requested a recycle because the worker process
reached its allowed processing time limit.

Followed by one:
A process serving application pool 'DefaultAppPool' exceeded time limits
during
shut down. The process id was 'xxxx'.

System Log fills with this stuff every 5-10 seconds. I have configured
recycle every 2 minutes in pool ,if not IIS totaly stops responding after
some time.

IISState shows only that what I already know, how i could point out the
problem?
I have several requests which are stuck waiting for a non-existent
thread and this is the problem so far.

Here is the asp code example that we have in average all our pages:

<%
var qstring="dsn=mydsn;uid=user;pwd=pass"

var ServerConnection=Server.CreateObject("ADODB.Connection"), RecordClone,
query;

//Initialize server connection
function CreateServer()
{
        ServerConnection.Open(qstring);
}

//Finilize server connection
function DeleteServer(){
        ServerConnection.Close();
        ServerConnection=null;
}

//Function than runs sql query and in case of error parses error description
function runSQL(query) {
        try {
        RecordClone=ServerConnection.Execute(query);
        return RecordClone;
        }
        catch (exception) {
        Response.Write("<!--ERROR WAS ON PAGE: "+exception.description+"-->");
        }
}

CreateServer();
...

var data = runSQL("select xx from yy"); //lots of simple queries
runSQL("update xx set yy=zz");

...

DeleteServer();
%>

Nothing special as you see. ODBC connection, some simple queries, html
output and thats all. Same sql queries which I launch in asp, through query
analyzer runs in 0 secs
We have windows2003(mdac 2.8), sql2000, iis6 and asp/asp.net applications on
it, also
sometimes we access sql server through access 2000/xp applications.Previously
we had win2k and iss5 same trouble. And yes, we have Iframes in asp pages.
Overall system serves 50 users, approx 10 of them use server simultaneously
at one moment.

"Pat [MSFT]" rakstîja:

> IISState couldn't get to microsoft.com to get the symbols, so I can't tell
> you much. But it does look like you are having a problem either in the
> parsing of the query or processng the results. It doesn't look like there
> is a problem w/the SQL server.
>
> I would guess that you may have some query coming back that is huge (i.e.
> Select * FROM myTableOfOneMillionRows ).
>
> Pat
>
> "Janis Buks" <JanisBuks@discussions.microsoft.com> wrote in message
> news:63C8FBCF-8469-45D7-9CF6-3254EC10FCCE@microsoft.com...
> > Where could be problem in my IIS? Processing SQL is very slow sometimes.
> > Here is IISState log:
> > ***********************
> > Starting new log output
> > IISState version 3.0
> >
> > Tue Nov 02 15:52:20 2004
> >
> > OS = Windows 2003 Server
> > Executable: w3wp.exe
> > PID = 304
> >
> > Note: Thread times are formatted as HH:MM:SS.ms
> >
> > ***********************
> >
> >
> >...

Relevant Pages

  • FW: Microsoft Security Advisory MS 03-007
    ... am trying to find a vulnerability tester/script and I could test it out ... Department of the Army server that had been compromised and that this ... announcement covers IIS 5.1 but not IIS 6, ... How a Hacker Uses SQL Injection to Steal Your SQL Data! ...
    (Focus-Microsoft)
  • Re: IISState log (IIS slow)
    ... It doesn't matter if the file does not have any ASP code in it or not. ... former is handled directly by the IIS Static file handler, ... which under any sort of appreciable load means your server is ... reached its allowed processing time limit. ...
    (microsoft.public.inetserver.iis)
  • RE: Confusion on standard security methodologies.
    ... Application will talk to a back-end SQL ... By "back-end," I assume you mean on a different box from IIS? ... If SQL is on a separate box, you won't be able to use NT authentication ... impersonations (meaning that once passed to the IIS server, ...
    (microsoft.public.inetserver.iis.security)
  • RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
    ... MS patch-scanner for Win-NT, 2K, IIS, SQL ... XML file from the following location - mssecure.xml Possible ... and on a NT 4 Server, but the scanner works fine on a W2K Server ...
    (Focus-Microsoft)
  • Re: IISState log (IIS slow)
    ... But it's only way to return IIS to normal life. ... > It doesn't matter if the file does not have any ASP code in it or not. ... which under any sort of appreciable load means your server is ... > reached its allowed processing time limit. ...
    (microsoft.public.inetserver.iis)