dotnet remoting: We are hosting our remoting through windows services. The remote class is
basically a data access component. So, in the client application will call
the remoting object passing in a stored procedure and its parameters and the
function passes back a dataset. The problem is that if you watch in task
manager the memory usage increases but nevers goes down. I would appreciate
any help in helping to troubleshooting this. We have tried to rewrite the
code several different ways and set the remoting service to SingleCall and
Singleton but can't seem to pin down the problem. I have included some code
below to show what we are doing basically, but I am not sure what else to
look for or what would be helpful. Thanks in advance!


The call to the remoting object:
Dim myDal As DAL = CType(Activator.GetObject(GetType(DAL),
"tcp://server:1234/DAL.rem"), DAL)
Dim ds As DataSet = myDal.ExecuteSPReturnDataSet("spGetLogger")
DataGrid1.DataSource = ds.Tables(0)
ds.Dispose()
ds = Nothing
myDal = Nothing
GC.Collect()

The class in the remoting service:
Public Class DAL : Inherits MarshalByRefObject

The function that is called in the remoting service:
Public Function ExecuteSPReturnDataSet(ByVal strSpName As String, Optional
ByVal arrParamDetails As ArrayList = Nothing) As DataSet
Dim ds As DataSet

Try
ds = objDbAccess.ExecuteSPReturnDataSet(strSpName,
arrParamDetails)
Return ds

Catch ex As Exception
Throw ex

Finally
ds.Dispose()
ds = Nothing
GC.Collect()
End Try

=?Utf-8?B?SGVhdGhlclM=?= <HeatherS@discussions.microsoft.com> wrote in
news:9153429B-15C6-4175-8642-D9714C60E3F2@microsoft.com:

[quoted text, click to view]

Are you sending large data sets back to the client?

Hello.

Is there [MTAThread] attribute in the Main method of yours Service
class?
I've got the same problem as you (C# remoting hosting service memory
always grows) and this attribute has solved the problem.

See http://udidahan.weblogs.us/archives/015716.html for details.

They are not large datasets. We ran into that problem already and after some
research wrote a surrogate class to serial the dataset differently. I am not
as concerned that it uses memory though, but that it never gives it back.
So, it doesn't matter if it is small datasets, eventually the service maxs
out its the memory allocated to it.

[quoted text, click to view]