Search results matching tag 'memory leak'

ASP SQL Server connection pooling - is this normal?

withag — Tue, 07 Oct 2008 15:21:06 GMT

My company is responsible for a website for a well known british organisation that receives a massive amount of traffic daily. However its also one of our oldest sites and one of the few still running on ASP. Thankfully its attached to SQL server and not Access!

Recently we started getting the ambigous "Server does not exist or access denied" message during high traffic periods (lunch times, weekends) and we eventually figured it was a connection pooling issue.

I had a look at the code and the original developer used an include file at the start of each page with

Set connection = Server.CreateObject("ADODB.Connection")
connection.open connstring

Subsequent functions would then call

Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sQuery connection

Although rs.close was employed (but not always set rs = nothing) I noticed that at no time was connection.close ever called. So I tried to add an include file at the base of the page containing

connection.close
set connection = nothing

However this causes "object does not exist" errors. It seems that the connection object is implicitly closing - but I'm guessing not always.

I've been gradually going through the code and changing key pages and functions so that they don't call on this global connection object and instead creating local connection objects which I explicity close and set to nothing as soon as the query/recordset is no longer needed. In the meantime obscure code which I haven't yet got to is still calling the original connection object.

Please understand I'm doing this incrementally to the live site because its the only way I can monitor the results under high traffic.
Before I did this, in SSMS 2005 Activity Monitor there would only need to be 6 or so processes attached to the database for the site to fall over momentarily. Since the code changes I've seen upwards of 15 separate processes calling the database in Activity Monitor but the site is as fast as lightning, where previously I think it would have falled over by now.

Is this a sign that my code changes are doing the right thing and the site is pooling better under heavy loads by adding the extra processes as it needs them or that I've just messed things up further by introducing the additional connection objects?

I'm not from a classic asp background, I made the switch to ASP.NET from PHP so some code is a bit foreign to me when I look at this project. We don't have any .NET sites that attract anywhere near as much traffic as this site so I have nothing to compare to, but most of these rarely show more than one or two processes in Activity Monitor.

IIS 5 and ASP Crashes everymorning....Please help

universalkida — Thu, 20 Mar 2008 06:54:33 GMT

IIS 5 and ASP application crashes every day since last 2 weeks, haven't been able to figure out the reason for it. Just a light over it, upon crashing IIS still shows static files which helps understand that the IIS is working fine except that it cannot interpret ASP. There is a major memory leak because of which this issue is taking trips.

Any help appreciated, attached is the debug reports....

Analysis Summary
Type Description Recommendation
Error In DLLHOST.EXE__IIS-{Site_ ********* __Root}__PID__11960__Date__03_19_2008__Time_05_09_22PM__330__Manual Dump.dmp the

assembly instruction at KERNEL32!RaiseException+56 in C:\WIN2K\system32\KERNEL32.DLL from Microsoft Corporation has caused an

unknown exception (0xe06d7363) on thread 0

This exception originated from msvcrt!_CxxThrowException+34. Review the faulting call stack for thread 0 to determine root

cause for the exception.

Please follow up with vendor Microsoft Corporation for problem resolution concerning the following file:

C:\WIN2K\system32\msvcrt.dll.
Error The following threads in DLLHOST.EXE__IIS-{Site_ *********

__Root}__PID__11960__Date__03_19_2008__Time_05_09_22PM__330__Manual Dump.dmp are blocked by an unhandled exception

( 0 )

100.00% of threads blocked

Please see the Recovered Call Stack for thread 0 based on the restored exception and context record passed to the exception

filter.
Information Symbols were not available to resolve the symbol "comsvcs!g_pAppTrackerObject". The COM+ STA ThreadPool report

may not be accurate. Ensure that a symbol path is configured, enabling the proper symbols to be loaded.

To modify or view the current symbol path from within DebugDiag, select Symbol File Path from the File menu. If symbols

aren't available and/or a proper symbol path is already setup, then these threads should be manually reviewed further to

determine what they are doing. For more information regarding debug symbols for Microsoft components, please visit the

following site:

Debugging Tools and Symbols: Getting Started


Analysis Details
Table Of Contents
DLLHOST.EXE__IIS-{Site_ ********* __Root}__PID__11960__Date__03_19_2008__Time_05_09_22PM__330__Manual Dump.dmp

   Top 5 threads by CPU time

   Thread report

   COM+ STA ThreadPool Report

   Well-Known COM STA Threads Report

   ASP Report

Report for DLLHOST.EXE__IIS-{Site_ ********* __Root}__PID__11960__Date__03_19_2008__Time_05_09_22PM__330__Manual Dump.dmp
Type of Analysis Performed   Hang Analysis
Machine Name   mach123
Operating System   Windows 2000 Service Pack 4
Number Of Processors   4
Process ID   11960
Process Image   C:\WIN2K\system32\DLLHOST.EXE
System Up-Time   72 day(s) 06:28:51
Process Up-Time   0 day(s) 07:14:41

Top 5 Threads by CPU time
Note - Times include both user mode and kernel mode for each thread Thread ID: 0     Total CPU Time: 0 day(s) 00:00:00.0

Entry Point for Thread: 458f710

In DLLHOST.EXE__IIS-{Site_ ********* __Root}__PID__11960__Date__03_19_2008__Time_05_09_22PM__330__Manual Dump.dmp the

assembly instruction at KERNEL32!RaiseException+56 in C:\WIN2K\system32\KERNEL32.DLL from Microsoft Corporation has caused an

unknown exception (0xe06d7363) on thread 0

This exception originated from msvcrt!_CxxThrowException+34.
Thread report

Thread 0 - System ID 9096
Entry point   458f710
Create time   19/03/2008 15:47:25
Time spent in user mode   0 Days 0:0:0.0
Time spent in kernel mode   0 Days 0:0:0.0

This thread is blocked by an unhandled exception

Function   Source
KERNEL32!RaiseException+56
msvcrt!_CxxThrowException+34
mfc42!Ordinal1266
mfc42!Ordinal824+18
mfc42!Ordinal3030+60
sqresus+1657
NTDLL!LdrpCallInitRoutine+14
NTDLL!LdrShutdownProcess+11d
KERNEL32!ExitProcess+51
msvcrt!exit+c0
msvcrt!raise+98
msvcrt!abort+e
msvcrt!terminate+5b
msvcrt!__CxxUnhandledExceptionFilter+23
KERNEL32!UnhandledExceptionFilter+86
KERNEL32!BaseThreadStart+65

Recovered stack for thread 0

Function     Arg 1     Arg 2     Arg 3   Source
KERNEL32!RaiseException+56     e06d7363     00000001     00000003
msvcrt!_CxxThrowException+34     0234f444     6c428038     6c44b760
mfc42!Ordinal1266     00000000     6c3e0b7c     00000118
mfc42!Ordinal824+18     00000001     00000000     6c3e0eff
mfc42!Ordinal3030+60     08cc0000     00000000     00000001
sqresus+1657     08cc0000     00000000     00000001
NTDLL!LdrpCallInitRoutine+14     08cc1607     08cc0000     00000000
NTDLL!LdrShutdownProcess+11d     00000000     00000001     78040ab0
KERNEL32!ExitProcess+51     00000003     00000000     78007ce7
msvcrt!exit+c0     00000003     7c57a0a8     00000000
msvcrt!raise+98     00000016     0000000a     7800694e
msvcrt!abort+e     7c57a0a8     0234f9dc     00000000
msvcrt!terminate+5b     0234f9dc     7c58aa90     0234f9dc
msvcrt!__CxxUnhandledExceptionFilter+23     0234f9dc     7c57a0a8     00000000
KERNEL32!UnhandledExceptionFilter+86     0234f9dc     7c57e5e6     0234f9e4
KERNEL32!BaseThreadStart+65     7ce85ae5     0458f710     00000000

Back to Top

COM+ STA ThreadPool Report
Max STA Threads     100
Min STA Threads     11
Current STA Threads     87
g_activitiesPerThread     1
EmulateMTSBehavior     False
STA Threads In-Call     0 (none)

Note: There was an error collecting details for the COM+ STA Threadpool threads. The internal COM+ data structures may have

been corrupted.

Well-Known COM STA Threads Report
STA Name    Thread ID    Thread Status    Call Status

ASP report
Executing ASP requests   0 Request(s)
ASP templates cached   24 Template(s)
ASP template cache size   1,977.75 KBytes
Loaded ASP applications   1 Application(s)
ASP.DLL Version    5.0.2195.6672

ASP application report
ASP application metabase key    /LM/W3SVC/90462893/Root
Physical Path   \\fileDump1234\DOCS$\*************\
Virtual Root   /
Session Count   117 Session(s)
Request Count   2 Request(s)
Session Timeout   60 minutes(s)
Path to Global.asa   \\fileDump1234\DOCS$\*************\GLOBAL.ASA
Server side script debugging enabled   False
Client side script debugging enabled   False
Out of process COM servers allowed   False
Session state turned on   True
Write buffering turned on   True
Application restart enabled   True
Parent paths enabled   False
ASP Script error messages will be sent to browser   True

ASP Template Cache report
ASP Template for    \\fileDump1234\DOCS$\*************\LOGON.ASP
Application URL   http://*********2.***************/
Application Path   /
Template Size   76188 bytes
# of files in Template   7 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\LOGON.ASP   28/02/2007 16:55:54

         \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

            \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

            \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

            \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

         \\fileDump1234\DOCS$\*************\HEADING.HTM   30/07/2002 19:21:00

         \\fileDump1234\DOCS$\*************\MESSAGE.ASP   25/05/2005 10:32:54

ASP Template for    \\fileDump1234\DOCS$\*************\GLOBAL.ASA
Application URL   http://*********2.***************/
Application Path   /
Template Size   4228 bytes
# of files in Template   2 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\GLOBAL.ASA   17/03/2008 19:19:11

         \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\STATEMENT.ASP
Application URL   http://*********2.***************/
Application Path   /
Template Size   56229 bytes
# of files in Template   7 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\STATEMENT.ASP   25/04/2005 15:27:26

         \\fileDump1234\DOCS$\*************\HEADING.HTM   30/07/2002 19:21:00

         \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

            \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

            \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

            \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

         \\fileDump1234\DOCS$\*************\MESSAGE.ASP   25/05/2005 10:32:54

ASP Template for    \\fileDump1234\DOCS$\*************\MENU.ASP
Application URL   http://*********2.***************/
Application Path   /
Template Size   77442 bytes
# of files in Template   7 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\MENU.ASP   30/03/2007 13:03:07

         \\fileDump1234\DOCS$\*************\HEADING.HTM   30/07/2002 19:21:00

         \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

            \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

            \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

            \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

         \\fileDump1234\DOCS$\*************\MESSAGE.ASP   25/05/2005 10:32:54

ASP Template for    \\fileDump1234\DOCS$\*************\DB\ERRORDISPLAY.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   5891 bytes
# of files in Template   2 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\DB\ERRORDISPLAY.ASP   13/06/2005 10:44:28

         \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\LEO\DEFAULT.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   105518 bytes
# of files in Template   9 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\LEO\DEFAULT.ASP   23/05/2006 16:30:17

         \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

            \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

            \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

            \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

         \\fileDump1234\DOCS$\*************\Xlpore\COMMON.INC   17/06/2005 14:06:36

            \\fileDump1234\DOCS$\*************\Xlpore\ADOVBS.ASP   02/04/2002 10:42:06

         \\fileDump1234\DOCS$\*************\CALENDAR\INCLUDES\CAL.ASP   17/01/2006 05:53:34

         \\fileDump1234\DOCS$\*************\LEO\TOP.ASP   14/12/2005 07:21:32

ASP Template for    \\fileDump1234\DOCS$\*************\LEO\PROCESSVAL.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   144750 bytes
# of files in Template   7 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\LEO\PROCESSVAL.ASP   27/02/2007 17:36:27

         \\fileDump1234\DOCS$\*************\CALENDAR\INCLUDES\CAL.ASP   17/01/2006 05:53:34

         \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

            \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

            \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

            \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

         \\fileDump1234\DOCS$\*************\LEO\TOP.ASP   14/12/2005 07:21:32

ASP Template for    \\fileDump1234\DOCS$\*************\LEO\INSERTVAL.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   173188 bytes
# of files in Template   6 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\LEO\INSERTVAL.ASP   08/05/2007 19:40:30

         \\fileDump1234\DOCS$\*************\DB\ADO.ASP   10/06/2005 10:48:26

            \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

               \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

               \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

               \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\ACCOUNT.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   76816 bytes
# of files in Template   6 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\ACCOUNT.ASP   25/04/2005 15:25:24

         \\fileDump1234\DOCS$\*************\HEADING.HTM   30/07/2002 19:21:00

         \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

            \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

            \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

            \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\comm\CONTENT\SEARCHTICKET.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   226023 bytes
# of files in Template   7 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\comm\CONTENT\SEARCHTICKET.ASP   27/09/2007 17:33:50

         \\fileDump1234\DOCS$\*************\DB\ADO.ASP   10/06/2005 10:48:26

            \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

               \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

               \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

               \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

         \\fileDump1234\DOCS$\*************\CALENDAR\INCLUDES\CAL.ASP   17/01/2006 05:53:34

ASP Template for    \\fileDump1234\DOCS$\*************\ADMIN\MENU.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   59495 bytes
# of files in Template   6 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\ADMIN\MENU.ASP   25/04/2005 15:23:40

         \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

            \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

            \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

            \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

         \\fileDump1234\DOCS$\*************\ADMIN\HEADING.HTM   05/07/2005 16:01:28

ASP Template for    \\fileDump1234\DOCS$\*************\ADMIN\SYSTEMMENU.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   57347 bytes
# of files in Template   6 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\ADMIN\SYSTEMMENU.ASP   11/10/2005 09:25:34

         \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

            \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

            \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

            \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

         \\fileDump1234\DOCS$\*************\ADMIN\HEADING.HTM   05/07/2005 16:01:28

ASP Template for    \\fileDump1234\DOCS$\*************\ADMIN\RULES.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   72103 bytes
# of files in Template   7 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\ADMIN\RULES.ASP   24/05/2005 11:35:56

         \\fileDump1234\DOCS$\*************\ADMIN\INCLUDES\FUNCTIONS.JS   17/03/2005 14:09:54

         \\fileDump1234\DOCS$\*************\ADMIN\HEADING.HTM   05/07/2005 16:01:28

         \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

            \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

            \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

            \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\comm\CONTENT\GETUSERDETAILS.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   58989 bytes
# of files in Template   6 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\comm\CONTENT\GETUSERDETAILS.ASP   25/07/2007 12:11:48

         \\fileDump1234\DOCS$\*************\DB\ADO.ASP   10/06/2005 10:48:26

            \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

               \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

               \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

               \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\LEO\ABORTVAL.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   66240 bytes
# of files in Template   6 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\LEO\ABORTVAL.ASP   27/07/2006 17:36:15

         \\fileDump1234\DOCS$\*************\DB\ADO.ASP   10/06/2005 10:48:26

            \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

               \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

               \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

               \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\LEO\DISPLAYLEO.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   131405 bytes
# of files in Template   8 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\LEO\DISPLAYLEO.ASP   27/07/2006 17:36:20

         \\fileDump1234\DOCS$\*************\DB\ADO.ASP   10/06/2005 10:48:26

            \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

               \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

               \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

               \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

         \\fileDump1234\DOCS$\*************\CALENDAR\INCLUDES\CAL.ASP   17/01/2006 05:53:34

         \\fileDump1234\DOCS$\*************\LEO\TOP.ASP   14/12/2005 07:21:32

ASP Template for    \\fileDump1234\DOCS$\*************\BROADCAST.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   101437 bytes
# of files in Template   5 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\BROADCAST.ASP   17/01/2008 14:24:40

         \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

            \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

            \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

            \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\comm\CONTENT\EDITDETAILS.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   145783 bytes
# of files in Template   6 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\comm\CONTENT\EDITDETAILS.ASP   02/10/2007 08:43:26

         \\fileDump1234\DOCS$\*************\DB\ADO.ASP   10/06/2005 10:48:26

            \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

               \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

               \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

               \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\comm\CONTENT\INTERMEDIATE.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   65301 bytes
# of files in Template   6 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\comm\CONTENT\INTERMEDIATE.ASP   25/06/2007 18:01:34

         \\fileDump1234\DOCS$\*************\DB\ADO.ASP   10/06/2005 10:48:26

            \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

               \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

               \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

               \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\comm\CONTENT\ADDDETAILS.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   164207 bytes
# of files in Template   6 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\comm\CONTENT\ADDDETAILS.ASP   06/11/2007 17:37:21

         \\fileDump1234\DOCS$\*************\DB\ADO.ASP   10/06/2005 10:48:26

            \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

               \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

               \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

               \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\comm\CONTENT\DOVALIDATIONS.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   60925 bytes
# of files in Template   6 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\comm\CONTENT\DOVALIDATIONS.ASP   21/09/2007 17:44:33

         \\fileDump1234\DOCS$\*************\DB\ADO.ASP   10/06/2005 10:48:26

            \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

               \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

               \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

               \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\APPLY.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   74343 bytes
# of files in Template   6 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\APPLY.ASP   27/02/2007 17:38:46

         \\fileDump1234\DOCS$\*************\HEADING.HTM   30/07/2002 19:21:00

         \\fileDump1234\DOCS$\*************\DB\OO4O.ASP   07/02/2008 06:31:11

            \\fileDump1234\DOCS$\*************\DB\ORACONST.ASP   19/11/2002 16:18:42

            \\fileDump1234\DOCS$\*************\DB\ERRORS.ASP   13/04/2006 17:19:29

            \\fileDump1234\DOCS$\*************\DB\CONNECTIONS.ASP   01/02/2008 19:19:04

ASP Template for    \\fileDump1234\DOCS$\*************\FAQ.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   4727 bytes
# of files in Template   1 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\*************\FAQ.ASP   01/08/2007 17:34:54

ASP Template for    \\fileDump1234\DOCS$\ERRORTRAP.ASP
Application URL   http://*********.***************/
Application Path   /
Template Size   16639 bytes
# of files in Template   1 file(s)
Include Heirarchy
      \\fileDump1234\DOCS$\ERRORTRAP.ASP   18/09/2006 14:49:35

Script Summary
Script Name Status Error Code Error Source Error Description Source Line
IISAnalysis.asp Completed

SQL Server connection

tolgs — Fri, 11 Jan 2008 01:30:24 GMT

We are using a dedicated Windows 2003 machine running IIS 6.0 and SQL Server 2005 (on the same machine). Our code is Classic ASP and recently our server became unresponsive during busy hours where only about 50 requests would execute (with long delay) and the rest would time out. For the site visitors the experience is a hung service with no response.

We want to make sure that there is no memory leak driven by our code and we've checked line by line to make sure that we are closing all connections and destroying objects. However, we also would like to validate the method we connect to the SQL database and would like the help of the community here. Below is the code we are using to connect and would appreciate if someone can skim over it and tell us we we should be doing something differently:

<%
Function glpCloseRst(objRst)
  If IsObject(objRst) Then
   If objRst.State = 1 Then
    objRst.Close
    Set objRst = Nothing
   End If
  End If
End Function

Function glpCloseDBConn (objDBConn)
  If IsObject(objDBConn) Then
   If objDBConn.State = 1 Then
    objDBConn.Close
    Set objDBConn = Nothing
   End If
  End If
End Function
%>

<%
ConnectionStrSQL = "Driver={SQL Native Client};Server=555.55.555.55;Database=dbname;Uid=username;Pwd=password;"
set connSQL = CreateObject("ADODB.Connection")
connSQL.open ConnectionStrSQL
%>

Dim allSQX
allSQLX = "SELECT * FROM TABLE WHERE id='something';"

Dim allRsX
Set allRsX = Server.CreateObject("ADODB.Recordset")
allRsX.Open allSQLX, connSQL, 3, 3

DO UNTIL allRsX.eof

...somestuff...

allRsX.movenext
LOOP

glpCloseRst(allRsX)
glpCloseDBConn(connSQL)
%>

many thanks

Memory leak with W3WP.EXE

chidambar — Thu, 03 Jan 2008 09:53:05 GMT

We are running a web portal which uses lot of xml/xsl files for rendering web pages. After loading these files we found that the memory consumption of the IIS 6.0 process (w3wp.exe) is increasing. This keeps on increasing as we load more and more XML documents. But the problem is that it is not releasing the memory consumed. We are using Windows 2003 SP2 box. We have aslo ensured that all objects of the XML DOM elements as well as other objects are closed.

Do anybody knows the solution for this problem?

W3WP.exe eating all my resources in Classic ASP application

Propertyshowrooms — Wed, 22 Aug 2007 15:37:01 GMT

Hi all,

I know this is probably an easy problem to fix, or at least I hope so, but for the life of me I can't figure out why the Private Bytes in my w3wp.exe process just keeps climbing until the application pool gets recycled. I have tried all the usual approaches to the problem such as ensuring all db connections are closed and killed off, making sure there are no infinite loops (well i tried to, hard to know) etc. No matter what I try, the memory usage just keeps creeping up by around 10Mb per minute. The weird thing is when I change one of the code files included on the page (a large one, around 70k), and upload it to the server, the memory usage of w3wp.exe drops back down to normal (around 50Mb) and begins creeping up again (almost as if the newly uploaded page had been loaded into memory several times and once the w3wp.exe process sees a fresh version it unloads them all only to begin again.)

This problem has been doing my head in for around 5 days now and any help at all would be appreciated,

Many thanks in advance,

Osh