I am writing an asp page that receives an XML document, parses it, and then
writes the data to a SQL Server database.

Using Server 2000 with IIS 5.0.

SQL Server is on a different server than the IIS machine.

After a number (>15) posts to the ASP page, the memory on the IIS machine
goes up and remains in use. The memory does not get released until IIS is
restarted.

What am I missing?

Thanks,

Doug Rixmann

The usage is about 2-3M files, 90-180 times a day. The usage is generally in
a 2-3 hour span during the day.

I have closed and set everything to nothing.

3-4 hours? Is this configurable?

[quoted text, click to view]

Some additional info:

These are some of the objects that are used.

Set FSO = server.createobject("Scripting.FileSystemObject")
Set TSO = FSO.OpenTextFile(ErrorFile, 8, true)
set conn = server.CreateObject("ADODB.Connection")
set adoRst = server.CreateObject("ADODB.Recordset")
set adoDest = server.CreateObject("ADODB.Recordset")
set xml = Server.createobject("MSXML2.DOMDocument")

and all are closed and set to nothing at the end.


[quoted text, click to view]

yes indeed it should work...

what i've ended up doing is changing the asp page so that it receives teh
xml and then moved the parsing bits into a service that resides on the
server.

it's a stupid (but working) work around for a problem that shouldn't really
be.

thanks for you thoughts though

[quoted text, click to view]

how huge is the usage ? sounds like IIS cache mechanism.
it should get stable after 3-4hrs, if it just keep on increasing
and not stop till no more memory available you should verify
your script.

Check if all resource are closed and set to =nothing when
no longer needed.

--
Regards,
Bernard Cheah
http://support.microsoft.com/
Please respond to newsgroups only ...



[quoted text, click to view]

It should be fine.
You can't configure the period, IIS auto fine tune
the usage and cache control.

--
Regards,
Bernard Cheah
http://support.microsoft.com/
Please respond to newsgroups only ...



[quoted text, click to view]

Do you have 'on error resume next' in your code. If so, are you handling errors properly? The reason I ask, is we may be masking an error that we need to
see. You probably will want to debug this to find out exactly what is going on. Grab IISstate from www.iisfaq.com and follow the directions for ASP hang.
Then, drop a new post here with IISstate log in the subject line.

Thank you. I hope this information is helpful.

Tim Coffey [MSFT]

This posting is provided “AS IS” with no warranties, and confers no rights. You assume all risk for your use. © 2001 Microsoft Corporation. All rights reserved.
--------------------
| From: "Bernard" <qbernard@hotmail.com>
| References: <j4Jgb.3182$G_.257030@news20.bellglobal.com> <OAoAX$TjDHA.1676@TK2MSFTNGP09.phx.gbl> <OIKgb.3363$G_.280161
@news20.bellglobal.com>
| Subject: Re: memory usage with objects and iis
| Date: Wed, 8 Oct 2003 10:56:15 +0800
| Lines: 69
| Organization: -
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.0
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Message-ID: <erCz8eUjDHA.1672@TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.inetserver.iis
| NNTP-Posting-Host: 203.115.210.200
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.iis:278649
| X-Tomcat-NG: microsoft.public.inetserver.iis
|
| It should be fine.
| You can't configure the period, IIS auto fine tune
| the usage and cache control.
|
| --
| Regards,
| Bernard Cheah
| http://support.microsoft.com/
| Please respond to newsgroups only ...
|
|
|
[quoted text, click to view]
| > The usage is about 2-3M files, 90-180 times a day. The usage is generally
| in
| > a 2-3 hour span during the day.
| >
| > I have closed and set everything to nothing.
| >
| > 3-4 hours? Is this configurable?
| >
[quoted text, click to view]
| > > how huge is the usage ? sounds like IIS cache mechanism.
| > > it should get stable after 3-4hrs, if it just keep on increasing
| > > and not stop till no more memory available you should verify
| > > your script.
| > >
| > > Check if all resource are closed and set to =nothing when
| > > no longer needed.
| > >
| > > --
| > > Regards,
| > > Bernard Cheah
| > > http://support.microsoft.com/
| > > Please respond to newsgroups only ...
| > >
| > >
| > >
[quoted text, click to view]
| > > > I am writing an asp page that receives an XML document, parses it, and
| > > then
| > > > writes the data to a SQL Server database.
| > > >
| > > > Using Server 2000 with IIS 5.0.
| > > >
| > > > SQL Server is on a different server than the IIS machine.
| > > >
| > > > After a number (>15) posts to the ASP page, the memory on the IIS
| > machine
| > > > goes up and remains in use. The memory does not get released until IIS
| > is
| > > > restarted.
| > > >
| > > > What am I missing?
| > > >
| > > > Thanks,
| > > >
| > > > Doug Rixmann
| > > >
| > > >
| > >
| > >
| >
| >
|
|
|