Application Pool crashing due to excesive memory use or ASP error - ASP problem

M

mettá

I have a web site on a shared server (Win2003) and occasionally the site
goes down with a message "Service Unavailable" The ISP says there must be a
problem with the ASP content and excessive use of the Application Pool is
causing the problem

I can't find the cause but wonder if putting

<%Session.Abandon%>

and /or

<%Session.Contents.RemoveAll()%>

on the DB output pages will help to clear the excessive memory usage???

Any ideas???

Thanks
M
 
A

Adrienne Boswell

I have a web site on a shared server (Win2003) and occasionally the
site goes down with a message "Service Unavailable" The ISP says there
must be a problem with the ASP content and excessive use of the
Application Pool is causing the problem

I can't find the cause but wonder if putting

<%Session.Abandon%>

and /or

<%Session.Contents.RemoveAll()%>

on the DB output pages will help to clear the excessive memory
usage???

Any ideas???

Thanks
M

Are you closing all record sets and closing the connection to the db?
For example I use on every page:

<!--#include file = "conn_inc.asp"--> <!-- this file opens a connection
to the db -->
</head>
<body>
<% 'query db
'put recordset into an array
'close recordset and set it to nothing
'loop through the array
%>
<!--#include file = "footer_inc.asp"--> <!-- this file contains
conn.close and set conn = nothing -->
</body>
 
A

Anthony Jones

mettá said:
I have a web site on a shared server (Win2003) and occasionally the site
goes down with a message "Service Unavailable" The ISP says there must be a
problem with the ASP content and excessive use of the Application Pool is
causing the problem

I can't find the cause but wonder if putting

<%Session.Abandon%>

and /or

<%Session.Contents.RemoveAll()%>

on the DB output pages will help to clear the excessive memory usage???

Any ideas???

Are you using the Session object at all?
If so what for? How much data are you storing in the session object

Are you using the Application object at all?
If so what for? How much data are you storing in the application object?

How many distinct clients are actively hitting your site?

If you believe that you have too many session objects lying around unused
then a quick fix would be to reduce the session timeout on the site a
little.

Do you use thirdparty COM DLLs in you app (e.g., things other than the
typical ADODB and MSXML components)?

Are you storing COM objects in the Application or Session object?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top