The Question and Answer Board

[gotmilk]

Dimension to bob [regarding] memory leak question.
... IIS process
... recordset
... users increased
... ODBC calls
... a class that wrapped the ODBC API
... monitored the application's memory
... when using parameters
...... the class was not calling SQLFreeStmt
......... with SQL_RESET_PARAMS
... when excution of queries were done
...... was calling SQLFreeStmt with SQL_CLOSE
......... but not a SQL_DROP
... it still bugs me that all this used to work fine
on the older machine...it's not like [on] the day you switched
to the new server [the] volume on the site increased, was it?
- Dimension

Posted by: Bob Zumbrunnen
In reply to: Dimension
... leading to think the issue may be
what you mentioned [with] session variables.
has clearing that out helped any?
... destroying the biggest/nastiest in code yesterday
or the day before, yet it crashed yesterday.
[but] don't know if any attention is paid to global.asa
once IIS has fired up, so if not, the change I made
to global.asa to destroy all of a session's variables
on a session ending won't have taken effect
until the reboot yesterday's crash made necessary.
... just got in, so don't know if the server crashed last night.
---
At this point (Friday 9pm est) iHub did crash again. - gotmilk
---
The new programmer's first task is to close/destroy
all recordsets in code immediately after the code is done
with them. Starting with the most frequently-used routines
and working her way down.
Matt has done a lot of this already, but... he's not always
clear where it's safe or appropriate to close a recordset.
The new programmer shouldn't have any trouble with that...
Question: Would memory leaks (and, as Luke and I were
discussing yesterday, closing a db connection might still
leave the recordset's memory space occupied but the
recordset inaccessible) of a kind drastic enough to crash
ASP manifest themselves as a consumption of memory
until none is left?
... server made it through the night without a reboot.
... just now configured World Wide Web Publishing Service
to restart itself on failure. I don't know for sure that the OS
will be aware of its failure, but we'll see.
[end.]

Posted by: IH Admin [Matt]
In reply to: Bob Zumbrunnen
That's not what's failing.
The ASP module is what is failing.
The WWWP handles anything
- HTML - which we know works even when ASP dies.
So, that won't do the trick. MB

Posted by: Bob Zumbrunnen
In reply to: IH Admin [Matt]
I don't see ASP listed as a separate service.
Do you know its name in Services?

Posted by: IH Admin [Matt]
In reply to: Bob Zumbrunnen
That's what I be sayin'.
There isn't (as far as I know) a separate service
for just ASP. WWWP handles HTML, ASP, any kind
of hosting. ASP.DLL is just a component/function
of WWWP. The only way WWWP would restart
upon failure is if the whole service died
-- only one function is dying. However, it's worth a shot.

Dimension,

In regards to what Matt said in the above copy & paste,
... isn't [a] separate service for just ASP
... ASP.DLL is just a component/function of WWWP
my Windows 3.1 time frame understanding
of ASP.DLL (Dynamic Link Library)
is that ASP is an executable called ASP.EXE
that runs as a seperate process
that was built from an ASP.C
that had many "include files" during the compile phase
like
#include <stdio.h>
#include <stdlib.h>
with the next phase being to link in Libraries,
which I believe are just pre-compiled sources,
with certain libraries not included here to be part
of the ASP.EXE, but "brought into" during execution
as them .DLL files so that they can be replaced with
another version/update, and used by ASP.EXE
without rebuilding ASP.EXE but simply to delete
the .DLL from the harddrive and replace it with another,
and then shutdown ASP and execute it again.
My reason to say this is based on what Matt said above.
... isn't [a] separate service for just ASP
... ASP.DLL is just a component/function of WWWP
Which makes its unclear if Matt is clear on this :o)
So, might it be helpful if Matt supply URL links
to the company web site that supplies ASP
so that we can search for a design specification of ASP,
or simply just a "what is this, how does ASP work..."
help file that BobZ hopefully know backwards
& forward, word for word with 100% clairity :o)
Others like me can also read it and just maybe not being
familiar with your cosing language can see a forest where
you and BobZ can't because the trees are in the way.

oug