ASP.net NOT Releasing Memory

[M.Ob]

Hello...

I am having issues with my asp.net apps not releasing memory. The
memory usage for the process w3p.exe continues to grow to it's
allowable limit and does not drop until the app pool is recycled. How
do I get it so that the memory is released when no longer needed? I
have tries setting up memory recycling at a lower limit than the
defaults, but it recycles way too much slowing down the webs.

Here is my setup:
Win 2k3 SBS
IIS 6
SQL Srvr 2000 sp3a

I have a seperate app pool for my .net webs set to recycle every 15
minutes.

Here is a sample data access function that I am using:
/*************** *************** *************** *************** ****/
public DataTable GetClosedPhysic alInventories()
{
SqlConnection connection = new SqlConnection( connectionStrin g );
SqlCommand command = new SqlCommand(
"ODN_PI_GetClos edPhysicalInven tories", connection );

command.Command Type = CommandType.Sto redProcedure;

SqlDataAdapter adapter = new SqlDataAdapter( );
DataSet ds = new DataSet();

try
{
adapter.SelectC ommand = command;
adapter.Fill( ds );
return ds.Tables[0];
}
catch ( System.Data.Sql Client.SqlExcep tion sqle )
{
throw new ODN_SupportLibr ary.OrderWebDot NetException(
"There was an error retrieving the list of CLOSED PIs.",
sqle.Message.To String() + "\n\nSQL Error Num: " +
sqle.Number.ToS tring() +
"\n\nStack Trace (Inner Exception):\n" +
sqle.StackTrace );
}
catch( Exception ex )
{
throw new ODN_SupportLibr ary.OrderWebDot NetException(
"There was an error retrieving the list of CLOSED PIs.",
ex.Message.ToSt ring() );
}
finally
{
connection.Clos e();
}
}
/*************** *************** *************** *************** ****/

Any help would be greatly appreciated.

M.Ob

[John Saunders]

"M.Ob" <[e-mail] t> wrote in message
news:c5******** *************** ***@posting.goo gle.com...

Hello...

I am having issues with my asp.net apps not releasing memory. The
memory usage for the process w3p.exe continues to grow to it's
allowable limit and does not drop until the app pool is recycled. How
do I get it so that the memory is released when no longer needed? I
have tries setting up memory recycling at a lower limit than the
defaults, but it recycles way too much slowing down the webs.

Here is my setup:
Win 2k3 SBS
IIS 6
SQL Srvr 2000 sp3a

Have you confirmed that physical memory usage is growing? In particular,
does disk I/O due to paging seem to correspond with the memory size?

It may be that you are seeing the virtual memory, which may or may not
correspond to physical memory usage.
--
John Saunders
johnwsaundersii i at hotmail

[Steve Drake]

You should really call dispose on all objects that implement it, eg the
command data adaptor, you can do this using the using pattern.

We have a few web apps that get used all the time these do not eat memory.

If you are creating lots off LARGE objects then this can cause memory go up
and up as the large object heap doesn't get defragmented.

Steve
"M.Ob" <[e-mail] t> wrote in message
news:c5******** *************** ***@posting.goo gle.com...

Hello...

I am having issues with my asp.net apps not releasing memory. The
memory usage for the process w3p.exe continues to grow to it's
allowable limit and does not drop until the app pool is recycled. How
do I get it so that the memory is released when no longer needed? I
have tries setting up memory recycling at a lower limit than the
defaults, but it recycles way too much slowing down the webs.

Here is my setup:
Win 2k3 SBS
IIS 6
SQL Srvr 2000 sp3a

I have a seperate app pool for my .net webs set to recycle every 15
minutes.

Here is a sample data access function that I am using:
/*************** *************** *************** *************** ****/
public DataTable GetClosedPhysic alInventories()
{
SqlConnection connection = new SqlConnection( connectionStrin g );
SqlCommand command = new SqlCommand(
"ODN_PI_GetClos edPhysicalInven tories", connection );

command.Command Type = CommandType.Sto redProcedure;

SqlDataAdapter adapter = new SqlDataAdapter( );
DataSet ds = new DataSet();

try
{
adapter.SelectC ommand = command;
adapter.Fill( ds );
return ds.Tables[0];
}
catch ( System.Data.Sql Client.SqlExcep tion sqle )
{
throw new ODN_SupportLibr ary.OrderWebDot NetException(
"There was an error retrieving the list of CLOSED PIs.",
sqle.Message.To String() + "\n\nSQL Error Num: " +
sqle.Number.ToS tring() +
"\n\nStack Trace (Inner Exception):\n" +
sqle.StackTrace );
}
catch( Exception ex )
{
throw new ODN_SupportLibr ary.OrderWebDot NetException(
"There was an error retrieving the list of CLOSED PIs.",
ex.Message.ToSt ring() );
}
finally
{
connection.Clos e();
}
}
/*************** *************** *************** *************** ****/

Any help would be greatly appreciated.

M.Ob