all groups > dotnet performance > march 2004 >
You're in the

dotnet performance

group:

Memory Leak asp.net/iis6/windows 2003/sql2000


Memory Leak asp.net/iis6/windows 2003/sql2000 jzink
3/30/2004 4:06:07 AM
dotnet performance:
Just implemented a production system using asp.net, iis6, sql2000 running on windows2003. Due to the iis6 settings of recyclying worker process every "n" minutes I didn't pick up during testing that there is a memory leak with the app. Narrowing it down even the following code causes a memory leak. Any ideas/suggesstions would be greatly appreciated
Memory will creep from 30K to 200K over the span of 24 hours

=========asp page code===========
private void testDB_Click(object sender, System.EventArgs e

TQIS_DS.User_PermissionDataTable userPermissions = UserPermissions.getSettings(utilities.getNTId())
userPermissions.Dispose()
userPermissions = null


===== data component code=============
public static TQIS_DS.User_PermissionDataTable getSettings(string NTId

TQIS_DS newDS = new TQIS_DS()
string[] tableList = new string[1] {"user_permission"}
SqlParameter [] arParms = new SqlParameter[1]
arParms[0] = new SqlParameter("@ntid", SqlDbType.Char,40)
arParms[0].Value = NTId
SqlHelper.FillDataset(ProjectVars.dataSource,"fe_getUserPermissions",newDS,tableList,arParms)
return newDS.User_Permission


===data access code==
Re: Memory Leak asp.net/iis6/windows 2003/sql2000 Alvin Bruney [MVP]
4/3/2004 7:46:02 PM
your best bet going forward is to take a memory dump and find out exactly
which objects are leaking memory. Studio ships with a memory dump utility

--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/27cok
[quoted text, click to view]
on windows2003. Due to the iis6 settings of recyclying worker process every
"n" minutes I didn't pick up during testing that there is a memory leak with
the app. Narrowing it down even the following code causes a memory leak.
Any ideas/suggesstions would be greatly appreciated.
[quoted text, click to view]
SqlHelper.FillDataset(ProjectVars.dataSource,"fe_getUserPermissions",newDS,t
ableList,arParms);
[quoted text, click to view]

AddThis Social Bookmark Button