Setting variables to nothing shortly before returning doesn't do anything for you in .NET...
Are you calling Dispose on all the ADO.NET objects you are creating? Even if you're not, the symptoms are a little odd. Do you have any static fields referring to collection classes anywhere? (E.g., do you have some kind of caching mechanism? Or maybe something that keeps track of objects that have been created?) Also, I would strongly recommend running it in the CLR profiler: http://www.microsoft.com/downloads/details.aspx?FamilyId=86CE6052-D7F4-4 AEB-9B7A-94635BEEBDDA&displaylang=en This will tell you what kinds of objects are taking all the memory. That may well give you a pretty quick route to finding out what's wrong. -- Ian Griffiths - DevelopMentor http://www.interact-sw.co.uk/iangblog/ > -----Original Message----- > From: Sinha, Amit (GE Energy, Non GE) > > I am facing remoting problem in DOTNET. The ASP.NET(nothing to do with > ASP.Net) application is hosted on > webserver and dataaccess component is hosted on another physical > server(Application Server). The activation mode of remote objects from web > server is 'SingleCall' and we are using 'tcp' channel for remoting. The > DataAccess class has following functions: > > 1) Function to execute sql > 2) Function to return dataset based on an sql statement > 3) Function to Update Dataset > 4) Function to execute stored procedure. > > In all these function calls, we are setting the objects to 'Nothing' in > the > finally block of try-catch statement. > > The actual problem is that after sometime the memory utilization of > remoting > service goes up 2 GB and it hangs the application server. > > Please throw your views if anyone has faced such problem before. =================================== This list is hosted by DevelopMentor� http://www.develop.com Some .NET courses you may be interested in: Essential .NET: building applications and components with CSharp August 30 - September 3, in Los Angeles http://www.develop.com/courses/edotnet View archives and manage your subscription(s) at http://discuss.develop.com
