Server Memory Leak
We are running asp (not asp.net) and vb com dll web sites on a machine which also has sql server 2000 sp3a running and uses Windows Server 2003. We recently migrated from Windows 2000 (same database) where we had no problems. However on the new machine, despite much being much more powerful and having the same usage, the box is periodically
grinding to a halt. The cause seems to be sql server using excessive amounts of memory, it steadily builds up to after a reboot to a high level. This seems to point in the direction of a memory leak, is anyone aware of any such problems with asp/sql server on windows 2003 and how to diagnose/fix them. I am aware of some unclosed connections in the asp code and objects that have not be set to nothing but this did not seem to cause a problem in the old machine and it is not practical to fix them all in the short term. I thought it might be unclosed connections although when I looked at SQL Server:General
Statistics and User Connections I did not seem to see a large or increasing number of connections.
View Replies
ADVERTISEMENT
I'm having a problem that I can only attribute to something that I don't
know about ADO. I am using an ADODB.Connection with .CursorLocation = 3
since I am using MSSQL with text fields.
I am running a large set of 4 LEFT JOINS (5 tables in all). Currently
my recordset is returning 168 rows and 23 colums. After looping through
the ADO connection 27 times (creating a pdf report for users to print)
the data goes nutz. I have tried using different inputs and no matter
what on the 27th time is stops.
View Replies
View Related
We are doing a stability test on our application to prepare for Microsoft
SQL Server 2000 certification, and we found a memory leak, but we cannot find
its source and fix it.
We use an ASP page written in JScript that connects to Analysis Services
2000 using ADOMD and retrieves data from it (this is a very simplified
version of our real application that we created just to test the memory
leak), see the code below.
We are using Microsoft Application Center Test to run this page, and
Performance Monitor to monitor the Memory/Committed Bytes and Processor usage
of our web server. The Memory/Committed counter slowly increases over time,
which indicates a memory leak, right? The Private Bytes for the InetInfo
process remain stable.
Our setup is a web server running Windows 2000 and Analysis Services on a
different server running Windows 2000. The application Center Test is running
from another computer. We also tried using a web server running Windows XP
Pro instead of Win2000, with similar results.
Using PerfMon, we monitor the number of Analysis Services connections, and
this number remains stable, so the memory leak doesn't seem to be due to an
ever increasing number of AS open connections.....
View Replies
View Related
Can this be the reason for huge memory expansion ? Doesn't this script free memory of the object it had created?
sub createCOMobject()
set obj1 = createObject("object1")
dim flag = 1
useObject flag,obj1
end sub
----------------------------------
sub useObject (flag, byRef obj1)
....
set obj1 = Nothing
end sub ....
View Replies
View Related
Anyone have any insights on how to debug a memory leak with a classic asp application?
View Replies
View Related
Im trying to track down a memory leak in one of our windows servers thats running W2k. Pretty basic install, although we have 3rd party software that simply blows.
Is there a way to check which ASP processes are running via command line, or another method on W2K/XP ?
View Replies
View Related
My webhosting company took down my website as it was causing a high memory use. Of course this happened just when I was on holiday ! Anyway I am trying to figure out what's going on. I didn't updated any script for more than 2 weeks before the abuse occured as I was on holiday. To make sure everything would be fine when away I had purge the database, defrag and compact it before leaving.
Any tools I can use to check out my site ? My host send me some log files created by Filemon but I can't really figure out what's wrong.
View Replies
View Related
I have implemented a content management system through ASP and XML files. I am using sessions for my login information. It is a fairly complex site and uses various personal options for clients like, my page, my setting and my e-cards. The database for the clients is kept on MS SQL server. ANd I am using ADODB to connect at various stages.
The problem is that when more than 10 people try to access the site at the same time, irrespective of which part they access, the site hangs and goes down. When I monitor the server for the problem, the memory free goes tremendously high, even for small no of connections. The connections keep on increasing at a fast pace till the website crashes and there are no more connections that can be added. I am currently trying the strategy of timeouts (decreasing them at various portions of the code) and also checking whether there are any open connections. But I am not able to check how many clients are ACTUALLY connected. I read Response.isClientConnected is a strategy....
View Replies
View Related
We have a web application in AS. It also uses COM+ and SQL Server as back-end. Sometimes the size of the dllhost.exe grows unexpectedly. It is such that we restart our IIS/ PWS. Also there is only one instance of dllhost running when we restart the webserver but later on we notice more than one instance sometimes.
View Replies
View Related
We have an webservice application that has a memory leak when the application
is compiled release mode. However, when the application is compiled in debug
mode it does not exhibit a memory leak.
We are running .net 1.1 compiled with VS 2003.
The application does reference an unmanaged dll that provides security
functionality. This dll is instantiated once and referenced on every web
service call.
View Replies
View Related
As I ran in to errors like "Ran out of memory" and "Out of memory" I
supposed my website might have memoryleaks. To trace a potential memory leak
I isolated the IIS process and monitored the 'Virtual Bytes' and 'Private
Bytes' for a while.
I noticed the private bytes stays 'low' all the time. Sometimes a bit up,
sometimes a bit down. Virtual bytes also follows the same pattern for most
times. But, sometimes it increases to almost 2gb en stays there.
I've been reading for memory leaks an aggressive caching and stuff and was
wondering when there is a memory leak. In short: what does it mean thet the
amount of virtual bytes stays high? Is this probably due to caching or....?
View Replies
View Related
I am getting the following error from my ASP application:
Microsoft VBScript runtime error '800a0007'
Out of memory: 'Server.CreateObject'
It always (as far as i have observed) occurs when i try to create a new
ADODB.connection object in my cCon helper function (opening a connection and
returning it):
Function cCon()
Dim cnRet
set cnRet = server.createobject("ADODB.Connection") 'This is where the
error is thrown
cnRet.connectionstring = GLB_CONSTR_DB
cnRet.open
Set cCon = cnRet
End Function
The page that errors will typically call this function 6- 10times from
different functions which handle their connections in this way: Code:
View Replies
View Related
I am hosting hundreds of websites on a webserver using a combination of sql and asp.
SQL is on a different server. The web server is running win 2003 iis 6 with a single processor and 1 GB Ram. All websites are in 1 app pool.
I find that i get out of memory errors or no new sessions are created when the virtual bytes for an App pool starts to breach over 1500mb. So i recycle the App pool at a limit of 1500mb.
This leads to the app pool recycling 1-2 times a day. Typically the Private Bytes counter is saying 293mb and virtual bytes is 1438mb. I don't know whether this is a leak somewhere in ASP or normal with IIS but the virtual bytes only seems to increase over time and not stablise or go down as i would expect when users visit and leave a website.
I have a script that i use to let uses download files from the server. It uses the response.binarywrite method. If i download a large files (i.e. over 100mb) then i see a big jump in the virtual bytes that IIS allocates in the w3wp.exe process. This does not appear to go down after the file has been downloaded although Private Bytes goes up and then down initially. I was thinking that this may be a cause of the problem?!
....or maybe it is typical for these types of large scale ASP applications? Would increasing the main memory RAM to 2GB help in this situation. The main Physical Memory still reports about 300mb free when i get the memory problems?
Would it help to split the websites into a couple of different App Pools, then increase the page file size to something larger and hence each App pool gets to use a separate 2GB memory space? Would i benefit from moving to Windows 64bit edition and installing more Ram and having a large Page file to cope with the large Virtual Bytes?
Can anyone offer some guidance who have had similar issues with hosting their sites?
View Replies
View Related
I get this error in trying to do recursive loops. My function to get the subordinates is: Code:
View Replies
View Related
I am creating an instance of MFC COM dll through ASP page.
It is giving me the following error.
Error Type:
Server object, ASP 0177 (0x8007000E)
Ran out of memory
Hardware spec:
p4, 256MB ram
OS: 2000 professional
IIS 5
Irrespective of the user under which virtual directory is running it throws this error. Probably its got to do something with permissions(NTFS).....
View Replies
View Related
How can a measure server session memory usage?
I have a 20-30 session variables and I would like to know how much they memory they consume then multplied with my projected user load.
View Replies
View Related
I am creating an instance of MFC COM dll through ASP page.
It is giving me the following error.
Error Type:
Server object, ASP 0177 (0x8007000E)
Ran out of memory ....
View Replies
View Related
Can anybody shed any light on this issue ??? Or even ways of temporaily
getting around it ???
FISH is an ASP application which uses a WSC object called "finapps.fishapp"
to handle the requests to the database. The WSC is created in the GLOBAL.ASA
as a Session object using the following line:
<OBJECT RUNAT=Server SCOPE=Session ID=fish
ClassID="{32f74dc1-40f8-4db3-98a7-000200040013}"> </OBJECT>
The finapps.fishapp object creates an "ADODB.Connection" object that is held
open while the session is running, and the Session_OnEnd event should call a
method of that object that closes the connections
The website falls over only when there has been a period of inactivity
greater than the length of the session timeout, and also after there has
been a significant amount of traffic prior to this!
The problem we have only occurs for one of our clients, but occurs seemingly
randomly on all 4 of their servers. The returned results of the error are as
follows:
-----------------------------------------------
Active Server Pages error '8002802b'
Create object failed
An error occurred while creating object 'fish'.
Microsoft VBScript runtime error '800a0007'
Out of memory: 'fish'
//global.asa, line 36
------------------------------------------------
View Replies
View Related
We're getting "ERROR (0x8007000E) Not enough storage is available to
complete this operation" errors on a fairly large, busy ASP/SQL Server web
site. The error is being thrown on a line calling oRs.GetRows() on one of
our busiest pages. The array returned from the GetRows() call will be
'cleaned up' when the page goes out of scope, but I wonder if we should be
calling Erase specifically after the last usage to explicitly free allocated
memory. Is there any actual benefit doing this cleanup explicitly? I've
always throught that ASP's memory deallocation was a bit spotty - can anyone
comment.
View Replies
View Related
We are receiving an error in our ASP website that used to run fine on our old servers but seems to be struggling on our new ones, I'm wondering if you've seen this error before?
Microsoft Cursor Engine error '8007000e'
Out of memory.
/oob/activities/default.asp, line 470
The last line that shows where the error happening is different on every page but it appears at the first database connection on each page.
The only way to get rid of the error and get the site working again is to recycle the application pool for the site (or restart IIS).
We have two servers, one running IIS and the other running MSSQL 2005. Both are the following specs: Code:
View Replies
View Related
I think I already know the answer ("NO"), but I figured I'd ask anyway:
Is there a way to populate a SQL-like object entirely in memory, without having to save it in a SQL-like environment like MySQL, MS-SQL, or Access?
I'd like to take the contents of some CSV's and dump them into a virtual SQL table, and then call from that table using a SQL statement ("SELECT * FROM VirtualTable WHERE Foo='Bar'"). I know that in .NET I could use a data-grid to do basically that, but I was wondering if there was a classic ASP solution.
View Replies
View Related
I am getting an ASP error.. that tells the server it is OUT OF MEMORY.then the server displays a message about the DLLHOST.exe and it waits for an "OK" from me.after hitting OK... it goes back to working fine.BUT, while the notification is up on the screen.the website is NOT AVAILABLE.that is the message that visitors get when they try to get to the website.so, is there a way I can tell the system to SKIP the notification .andmjust restart the service.
What memory is the issue here.I am assuming this memory error is coming from an INFINITE LOOP or something.from one of my ASP pages. so, I would imagine the best move would be to get RID of the "On Error Resume Next" code at the top of my pages.. to try and isolate the problem?
View Replies
View Related
Does any body know any tool that profiles Internet Explorer for memory
leaks.
View Replies
View Related
I am trying to write a search script in my spare time at work. We have a knowledge base consisting of 200+ .mht files. My script was working ok when I was testing it on just a few files but I am getting out of memory errors trying to search through the whole KB. Here is the search code:
View Replies
View Related
am just wondering is there a easier way to release all the memory after the program is done?or do I need to set all my variable = nothing one by one at the end of my code?
View Replies
View Related
We've got this problem on our site where slowly eats virtual memory until IIS stops serving pages...
Restarting the IIS process fixes the problem, until the next time it reaches that point. I've made sure all our ADO objects are being closed and set = Nothing. I don't know what else could eat up all that memory...
View Replies
View Related
I am trying to create a search script but I am running into an out of memory error. Here is the search subroutine which loops multiple times:
Code: .....
View Replies
View Related
Had developed a webpage to refresh automatically from one ASP page to another, with the feature of displaying local data that is actively poll & inserted from other remote database servers. The local server is using IIS & Microsoft SQL 2000. I have the problem of "Out of Memory at line 30" after the ASP page has ran for 13 hours, at client machines that is connecting to the server hosting the ASP. However by closing the Internet Explorer and re-open the ASP page, the problem is temporary resolved until another 13 hours later. I think i've had the server objects set to nothing, and had put all queries into sub. I couldn't think of other solution for the problem...
Is duplication of sub affecting the performance? Any setting to be done on server, e.g. IIS / SQL? I've attached the ASP file.
View Replies
View Related
Are there any tools to test asp code on memory leaks. Or the took that will monitor IIS server against specific asp-page in order to find mem leaks on in.
View Replies
View Related
I am trying to beef-up the security when passing data between pages. I am currently using the following code to navigate between some of my pages.
<a href="javascript: GetFormValue(FRMTRANSFERS.TXTHOSPITALID,'ADDPATIEN T');">
<SCRIPT LANGUAGE="JavaScript">
function GetFormValue(FField,StrPage)
{
var myField = FField
var myNumber = myField.value
self.location = StrPage + ".asp?ID=" + myNumber;
}
</SCRIPT>
I would rather use cookies to do this but i need to know if you can create a cookie that doesn't get written to the harddrive. I can't use session variables as i can't write then in Javascript - at least i think not -
View Replies
View Related
I have managed up to the point that a byte[] imageContent contains a picture which i can show in a aspx page by:
// return byte array to caller with image type
Response.ContentType = "image/jpeg";
Response.BinaryWrite(imageContent);
but what i need is to post it back to the page that the user entered various details without losing them.
View Replies
View Related
I have an asp page that displays the results in Excel in the browser.
It has about 40 columns and sometimes records can grow upto 1100.
For small number of records I do not get any error messages or displays
the result in Excel format properly. But for the higher number of
records even if the program runs for all day it hangs up and shows
nothing.
In the asp program I have many if and then statement as well as big
loop.
My question is how can I solve this problem? Do I have to look into the
web server memory and other configuration settings? Or is there a
maximum size limit in Excel.
View Replies
View Related
I have a page which sends a query to an DB2 using an ODBC. The
results are then written to a text file. I am unable to write directly to
the users drive because of permissions.
The problem I have is that when the
query set becomes too big, I get error '8007000e' Not enough storage is
available to complete this operation. The query is returning 100, 000
records or more. So my question is how do I handle this? Somebody had
suggested to me to chunk the data. Code:
View Replies
View Related
