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 ?
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.
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.....
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 ....
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.
Anyone have any insights on how to debug a memory leak with a classic asp application?
View Replies View RelatedMy 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.
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....
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 RelatedWe 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.
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....?
Im working on an automated email sending script which work real fine. I have to send 2 different list of email ( contact1 and contact2) of an acces database file (.mdb).
The fact is that my script work well but for some reason it only send the second list of email (contact2).
The script process the list contact1 without any error but obviously it isnt sending mail to those email.
It seems to be an easy fix mistake but i cant figure out why the first contact list isnt sending. Must be a "If then" mistake or something with the loop i think.
Heres the code: ......
How can i list out all the email address into my website from the hotmail caontact list? i am successful log in into the yahoo contact list by using serverxmlhttp and list out all the email address from the page source, but i could not access to hotmail by using the serverxmlhttp. Is any other methos can list out the email address from hotmail contact list?
View Replies View RelatedI'm a complete newbie to IIs and ASP (come from the Apache/Cold Fusion
world ). I've created a very simple ASP test page:
<%@ Language=VBScript %>
<% Response.Write "This is a test ASP page." %>
But when I access the page, it just displays the page as text, instead
of processing the ASP. I've looked at a half-dozen Microsoft KB
articles, but still no luck. I'm not getting an error, it's just not
processing.
I m facing a problem in ASP. That is on the production machine when I deploy my product at that time it dosenot perform a particular process. But on my devlopment machine it runs perfectly fine.
The only difference which lies is that on my devlopment machine in security tab of wwwroot/(website) a security permission with the name of VS Devlopers(machineVS Devlopers) exist but on the production machine it dosenot. What could be the possible problem.
Making good old fashioned asp page and need to be able to display the IIS COM+ process id's (i.e. those that show up when attaching to a process in InterDev(in debug/processes dialog box).
Is there a way to get these process id's show up in an asp page? You can tell I'm not to saavy when it comes to working my way around the WindowsAPI.
Just like to know if I am correct and no problems in this scenario:
I have page where the user clicks a button to save some information >>
gets directed to page 2 where a value gets returned from a recordset and the form is inserted automatically upon loading with the value (sequential for the database table) >>
the user then gets redirected to page 3 upon insertion into the database, if I use 'Select Top 1 ......' as a query to retrieve some information on this page am I sure that this is the correct record just inserted even if 2 or more people are saving at the same time?
i have to start a batch process from a dll to transfer
files created by this dll to remote ftp server. I created
a batch file:
ftp -n -v -i -s:D:atchftpcmds.txt ftp-server
and a file containing the ftp commands:
user username password
lcd D:atchmedia
mput *.*
quit
It works pefectly when i start it from the dosbox. But
when i call it from the vb dll implemented in IIS (shell
("D:atch ransfer.bat")), it does not complete the
transfer and hangs after 400-500 (small) files.
I need to select a csv file from my desktop through the "Browse.." button in my ASP page and upload the file and do further interrogation and extract the data to put into a database. What I'm struggling with is more the first parts with getting the file read properly in the second page so I can read and insert the data.The data below
describes the file. Quite a simple format.
Customer ID - Additional values are player IDs
193948294, 293, 294, 296, 290, 292
if it is possible to run a process after page has loaded? reason being is i have an application that uploads a file, then zip's it up. These are 50 megs sometimes, so zipping the file can take some time. It is a two stage process though, a user will upload a file, then fill out some more info, then submit, so while the user is filling out more info, I'd like to start zipping the file. Does anyone know if that is possible? and if so how to do it?
View Replies View Relatedwhen i call for a asp page i c some process still running in the status bar. but when i click on the same link again, i could not find the process. it happens alternatevely.why is this happening? how to prevent?
View Replies View RelatedIt's been a long time since I've needed any help with something, so I'm happy to come back and feel dumb again. I need to learn how to process XML data and generate pages driven from that data. I know the structure of the documents, I just need to grab the data from inside certain XML elements of the XML documents.
Can someone explain this or post a link to a good site? I've tried googling, but everything I find seems to explain how to print back the XML in HTML format.
Got a bit of code, which I want to loop through, unless the current value is "", in which case I need it to skip to the next one, but how do I do it?
Response.Write "<br />" & vbCrLf
For Each strItem In Request.Form
If strItem = "" THEN
'these next two lines, I only want to be processed if the above does
have a value in it
Response.Write "-" & strItem & "-" & vbCrLf
Response.Write "-" & Request.Form(strItem) & "<br />" & vbCrLf
End If
Next
Response.Write "<br />" & vbCrLf
Anybody have idea about Image processing tools available for ASP (like Imagemagick,I dont think ImageMagick will work with ASP).
I want to adjust the images uploaded to my site(ASP) to a particular resolution and do some image resolution changes, like creating thumbnails from originally uploaded images,etc..
I have created 2 tables on my db. one is for customers and one for corporate. this is to distinguish the records so that we wont mix up our clients. i have created a login page for both customer and corporate. however, i think there is something wrong with the login process code which process the login for users to our page. there is an error message:Error Type:
Provider (0x80020005)
Type mismatch.
(see highlight in red) for attached code.i am not sure if its correct but here is the code as attached
<%
Response.Buffer = True
strUserName = Request.Form("User_Name")
strPassword = Request.Form("User_Password")
Dim rs
Dim sqlStr
Dim record_found
record_found = 0
Dim vPath, pPath, ConString
vPath = "xxxxx.mdb" 'use this one if database is in root of cart folder
pPath = Server.MapPath( vPath )
ConString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & pPath & ";" & "JET OLEDB:"
Dim Conn, rsCatalog
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConString
sqlStr1 = "SELECT * from Customer WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'"
sqlStr2 = "SELECT * from Corporate WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'"
set rs = Server.CreateObject ("ADODB.Recordset")
adOpenStatic = 3
rs.CursorType = adOpenStatic
rs.Open sqlStr1, sqlStr2, conn
If (rs.RecordCount <= 0) Then
Response.Redirect("login.asp?from=no_record")
Else
record_found = 1
Response.Cookies("User_Name") = rs("User_Name")
Response.Cookies("User_Password") = rs("User_Password")
Response.Cookies("Login") = 1
Response.Cookies("View_Cart") = 0
End If
rs.Close
Set rs = Nothing
if record_found = 1 then
if Request.Form("hiddenVal") = "view_cart" then
Response.Redirect("view_cart.asp")
else
Response.Redirect("default.asp")
end if
end if
%>
I have few asp pages, which they get the information from a SQL server, while calling these pages, due to amount of data, sometimes it takes 10-15 seconds for loading the page.During this loading time I want to show the users something like a process bar so that the user is not left out with a blank page.
if anyone can guide me, how to show this process bar before completing the load process.
How to send data through winhttpd and process the data in the target page?
My asp.net code doesn't get executed by IIS. My file is
saved with .aspx extension. When i do a view source, all
the vb code is displayed. This shouldn't be visible if
the server is processing the code. How do i get IIS to
process my vb code is my .aspx files?
I'm developing an intranet application using W2k server and IE5.5 - 6.x
clients. I've got one particular function that calls a stored procedure to
update a number of records, depending on user input. The problem we have
run into is that this procedure can take a few minutes to complete in
certain circumstances, and of course IIS times out.
I've been doing some searching for a solution, but most of the answers I've
found relate to showing a 'Please wait' message while processing the page,
which doesn't help in this situation. The others I've found relate to using
MSMQ, which would probably help, but leads to a load of testing issues that
I'm not prepared to deal with at the moment.
Are there any other 'common' ways to handle this at the ASP level?
I am using Win2k, IIS 5 and vbscript as well as asp.
I want to run an asp page that creates a PDF (using a third party ASPPDF dll) as a background process to free up the main website as it takes about 3-4 minutes to render the PDF.
Any ideas on how to do this or where to look?
I'd like to process HTML documents in an ASP script, i.e. to remove any unwanted
elements and extract desired element and attributes. I know how to do it on
client side within IE using its HTML DOM. But what I'd like is to do it
server-side. Is there a way, for instance, to reuse MSIE technology to retrieve
interfaces like IHTMLElement, IHTMLDOMAttribute, aso, or just built-in features
that would allow me to do the same?
The asp script uses the WSHSHELL run method to launch a local application on the web server but The application process hangs each time when this is called from the web.
If the application is manually run from the command line or through a bat script (by double clicking on it), the application process launches and executes the batch file successfully.
If either of these actions are called from the .asp script, the application process.exe is seen running in the task manager and hangs.
i get data using getstring function. can i process this data using java script?
set rsShow = conn.Execute("SELECT league_E FROM Market M WHERE id=1113 ")
if not rsShow.eof then
aa=rsShow.getstring()
end if
rsShow.close
set rsShow=nothing