469,645 Members | 1,603 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

aspnet_wp.exe memory usage keep growing

hi,
i have an asp.net site and is using SQL Server 2k. i realize the
aspnet_wp.exe memory usage keep growing and i will receive an error for the
pages that call the sql connection. others page with no sql connection is
fined.
At the time when i encounter the error, i check the memory usage for

aspnet_wp.exe = 60000kb
sqlmangr.exe = 40000kb

at this time, if i terminated the aspnet_wp.exe from the task manager, my
asp.net web site will back to normal and this problem will occurs again once
the memory usage is hit to above the same values i mention above.

in my asp.net, i have several classes that have its own sqlconnection object
and at the end of code i always dispose the sqlcommand and sqlconnection
object and it still doesn't help to resolve the problem.
from my log record, i can see this problem only arrise when performing the
sql query like sqlcommand.executereader or sqlcommand.executenonquery and
etc.

Follwing is the spec for the software and hardware running the sql and
asp.net
Software Spec
1. .NetFramework 1.0 with SP2
2. Win2k Server with SP3
3. SQL Server 2000 with sp2

Hardware spec.
1. P4 Xeon processor
2. 512MB Ram

Please help!!!
Thanks
from clement
Nov 17 '05 #1
7 6943
60000KB is 60MB, which is not a lot or memory. ASP.Net uses garbage
collection to clean up unused memory. The garbage collection assures that
all unused objects will be removed from memory, but the trade-off is that
the objects are not removed immediately. There is a period of time during
which unused objects sit in memory waiting for garbage collection. For this
reason, a typical ASP.Net app will increase memory usage for a time after
which it levels off, and can even drop. But at 60MB of memory, you are not
using a lot of memory by ASP.Net standards.

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Clement" <bf***@hotmail.com> wrote in message
news:uF**************@TK2MSFTNGP10.phx.gbl...
hi,
i have an asp.net site and is using SQL Server 2k. i realize the
aspnet_wp.exe memory usage keep growing and i will receive an error for the pages that call the sql connection. others page with no sql connection is
fined.
At the time when i encounter the error, i check the memory usage for

aspnet_wp.exe = 60000kb
sqlmangr.exe = 40000kb

at this time, if i terminated the aspnet_wp.exe from the task manager, my
asp.net web site will back to normal and this problem will occurs again once the memory usage is hit to above the same values i mention above.

in my asp.net, i have several classes that have its own sqlconnection object and at the end of code i always dispose the sqlcommand and sqlconnection
object and it still doesn't help to resolve the problem.
from my log record, i can see this problem only arrise when performing the
sql query like sqlcommand.executereader or sqlcommand.executenonquery and
etc.

Follwing is the spec for the software and hardware running the sql and
asp.net
Software Spec
1. .NetFramework 1.0 with SP2
2. Win2k Server with SP3
3. SQL Server 2000 with sp2

Hardware spec.
1. P4 Xeon processor
2. 512MB Ram

Please help!!!
Thanks
from clement

Nov 17 '05 #2
check to see if you are running out of db connections.

are you exlicitly closing the connections to the database? before
disposing of the objct you need to call sql_connection.close

Clement wrote:
hi,
i have an asp.net site and is using SQL Server 2k. i realize the
aspnet_wp.exe memory usage keep growing and i will receive an error for the
pages that call the sql connection. others page with no sql connection is
fined.
At the time when i encounter the error, i check the memory usage for

aspnet_wp.exe = 60000kb
sqlmangr.exe = 40000kb

at this time, if i terminated the aspnet_wp.exe from the task manager, my
asp.net web site will back to normal and this problem will occurs again once
the memory usage is hit to above the same values i mention above.

in my asp.net, i have several classes that have its own sqlconnection object
and at the end of code i always dispose the sqlcommand and sqlconnection
object and it still doesn't help to resolve the problem.
from my log record, i can see this problem only arrise when performing the
sql query like sqlcommand.executereader or sqlcommand.executenonquery and
etc.

Follwing is the spec for the software and hardware running the sql and
asp.net
Software Spec
1. .NetFramework 1.0 with SP2
2. Win2k Server with SP3
3. SQL Server 2000 with sp2

Hardware spec.
1. P4 Xeon processor
2. 512MB Ram

Please help!!!
Thanks
from clement


Nov 17 '05 #3
firstly, thanks for your immediate reply.
thats right.
i had try to configure the machine.config at <processModel>memoryLimit = 40,
it still can't help. my asp.net program will hit to "404 page not found" or
just give me blank page.

by the way, i had also downloaded the iis5recycle.exe and i configure to run
the recycle when the momory goes to 50MB and it still not resolved the
problem.

appreciate ur help!!!
"Kevin Spencer" <ke***@SPAMMERSSUCKtakempis.com> wrote in message
news:u4**************@tk2msftngp13.phx.gbl...
60000KB is 60MB, which is not a lot or memory. ASP.Net uses garbage
collection to clean up unused memory. The garbage collection assures that
all unused objects will be removed from memory, but the trade-off is that
the objects are not removed immediately. There is a period of time during
which unused objects sit in memory waiting for garbage collection. For this reason, a typical ASP.Net app will increase memory usage for a time after
which it levels off, and can even drop. But at 60MB of memory, you are not
using a lot of memory by ASP.Net standards.

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Clement" <bf***@hotmail.com> wrote in message
news:uF**************@TK2MSFTNGP10.phx.gbl...
hi,
i have an asp.net site and is using SQL Server 2k. i realize the
aspnet_wp.exe memory usage keep growing and i will receive an error for

the
pages that call the sql connection. others page with no sql connection is fined.
At the time when i encounter the error, i check the memory usage for

aspnet_wp.exe = 60000kb
sqlmangr.exe = 40000kb

at this time, if i terminated the aspnet_wp.exe from the task manager, my asp.net web site will back to normal and this problem will occurs again

once
the memory usage is hit to above the same values i mention above.

in my asp.net, i have several classes that have its own sqlconnection

object
and at the end of code i always dispose the sqlcommand and sqlconnection
object and it still doesn't help to resolve the problem.
from my log record, i can see this problem only arrise when performing the sql query like sqlcommand.executereader or sqlcommand.executenonquery and etc.

Follwing is the spec for the software and hardware running the sql and
asp.net
Software Spec
1. .NetFramework 1.0 with SP2
2. Win2k Server with SP3
3. SQL Server 2000 with sp2

Hardware spec.
1. P4 Xeon processor
2. 512MB Ram

Please help!!!
Thanks
from clement


Nov 17 '05 #4
i do conn.close, conn.dispose and conn = nothing after use. by running the
SQL Profiller, i can see the sql db been called and there is always 1 or 2
connection pool in used. and the same pool will reused if not timeout.
"Kairi Zikpin" <zikkai.nospam.@netscape.net> wrote in message
news:3F**************@netscape.net...
check to see if you are running out of db connections.

are you exlicitly closing the connections to the database? before
disposing of the objct you need to call sql_connection.close

Clement wrote:
hi,
i have an asp.net site and is using SQL Server 2k. i realize the
aspnet_wp.exe memory usage keep growing and i will receive an error for the pages that call the sql connection. others page with no sql connection is fined.
At the time when i encounter the error, i check the memory usage for

aspnet_wp.exe = 60000kb
sqlmangr.exe = 40000kb

at this time, if i terminated the aspnet_wp.exe from the task manager, my asp.net web site will back to normal and this problem will occurs again once the memory usage is hit to above the same values i mention above.

in my asp.net, i have several classes that have its own sqlconnection object and at the end of code i always dispose the sqlcommand and sqlconnection
object and it still doesn't help to resolve the problem.
from my log record, i can see this problem only arrise when performing the sql query like sqlcommand.executereader or sqlcommand.executenonquery and etc.

Follwing is the spec for the software and hardware running the sql and
asp.net
Software Spec
1. .NetFramework 1.0 with SP2
2. Win2k Server with SP3
3. SQL Server 2000 with sp2

Hardware spec.
1. P4 Xeon processor
2. 512MB Ram

Please help!!!
Thanks
from clement

Nov 17 '05 #5
In .Net it is a waste of time to set an object to Nothing, BTW. That is
handled by Garbage Collection.

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Clement" <bf***@hotmail.com> wrote in message
news:eo**************@TK2MSFTNGP12.phx.gbl...
i do conn.close, conn.dispose and conn = nothing after use. by running the
SQL Profiller, i can see the sql db been called and there is always 1 or 2
connection pool in used. and the same pool will reused if not timeout.
"Kairi Zikpin" <zikkai.nospam.@netscape.net> wrote in message
news:3F**************@netscape.net...
check to see if you are running out of db connections.

are you exlicitly closing the connections to the database? before
disposing of the objct you need to call sql_connection.close

Clement wrote:
hi,
i have an asp.net site and is using SQL Server 2k. i realize the
aspnet_wp.exe memory usage keep growing and i will receive an error for
the
pages that call the sql connection. others page with no sql connection is fined.
At the time when i encounter the error, i check the memory usage for

aspnet_wp.exe = 60000kb
sqlmangr.exe = 40000kb

at this time, if i terminated the aspnet_wp.exe from the task manager, my asp.net web site will back to normal and this problem will occurs
again
once the memory usage is hit to above the same values i mention above.

in my asp.net, i have several classes that have its own sqlconnection object and at the end of code i always dispose the sqlcommand and
sqlconnection object and it still doesn't help to resolve the problem.
from my log record, i can see this problem only arrise when performing

the sql query like sqlcommand.executereader or sqlcommand.executenonquery and etc.

Follwing is the spec for the software and hardware running the sql and
asp.net
Software Spec
1. .NetFramework 1.0 with SP2
2. Win2k Server with SP3
3. SQL Server 2000 with sp2

Hardware spec.
1. P4 Xeon processor
2. 512MB Ram

Please help!!!
Thanks
from clement


Nov 17 '05 #6
got any idea for work around ?
i got an crazy idea to restart the IIS every 10 hours. but it is not the
final soulution.
any suggestion

"Kevin Spencer" <ke***@SPAMMERSSUCKtakempis.com> wrote in message
news:uF**************@TK2MSFTNGP12.phx.gbl...
In .Net it is a waste of time to set an object to Nothing, BTW. That is
handled by Garbage Collection.

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Clement" <bf***@hotmail.com> wrote in message
news:eo**************@TK2MSFTNGP12.phx.gbl...
i do conn.close, conn.dispose and conn = nothing after use. by running the
SQL Profiller, i can see the sql db been called and there is always 1 or 2 connection pool in used. and the same pool will reused if not timeout.
"Kairi Zikpin" <zikkai.nospam.@netscape.net> wrote in message
news:3F**************@netscape.net...
check to see if you are running out of db connections.

are you exlicitly closing the connections to the database? before
disposing of the objct you need to call sql_connection.close

Clement wrote:
> hi,
> i have an asp.net site and is using SQL Server 2k. i realize the
> aspnet_wp.exe memory usage keep growing and i will receive an error for
the
> pages that call the sql connection. others page with no sql connection is
> fined.
> At the time when i encounter the error, i check the memory usage for
>
> aspnet_wp.exe = 60000kb
> sqlmangr.exe = 40000kb
>
> at this time, if i terminated the aspnet_wp.exe from the task
manager, my
> asp.net web site will back to normal and this problem will occurs again
once
> the memory usage is hit to above the same values i mention above.
>
> in my asp.net, i have several classes that have its own

sqlconnection object
> and at the end of code i always dispose the sqlcommand and sqlconnection > object and it still doesn't help to resolve the problem.
> from my log record, i can see this problem only arrise when

performing the
> sql query like sqlcommand.executereader or
sqlcommand.executenonquery and
> etc.
>
> Follwing is the spec for the software and hardware running the sql

and > asp.net
> Software Spec
> 1. .NetFramework 1.0 with SP2
> 2. Win2k Server with SP3
> 3. SQL Server 2000 with sp2
>
> Hardware spec.
> 1. P4 Xeon processor
> 2. 512MB Ram
>
> Please help!!!
> Thanks
> from clement
>
>



Nov 17 '05 #7
As I mentioned in my previous reply, I don't think you have a problem. 60MB
is a small footprint for ASP.Net. If your machine can't handle the load, you
need more RAM. It's cheap!

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Some things just happen.
Everything else occurs.

"Clement" <bf***@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
got any idea for work around ?
i got an crazy idea to restart the IIS every 10 hours. but it is not the
final soulution.
any suggestion

"Kevin Spencer" <ke***@SPAMMERSSUCKtakempis.com> wrote in message
news:uF**************@TK2MSFTNGP12.phx.gbl...
In .Net it is a waste of time to set an object to Nothing, BTW. That is
handled by Garbage Collection.

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Clement" <bf***@hotmail.com> wrote in message
news:eo**************@TK2MSFTNGP12.phx.gbl...
i do conn.close, conn.dispose and conn = nothing after use. by running the SQL Profiller, i can see the sql db been called and there is always 1 or
2
connection pool in used. and the same pool will reused if not timeout.
"Kairi Zikpin" <zikkai.nospam.@netscape.net> wrote in message
news:3F**************@netscape.net...
> check to see if you are running out of db connections.
>
> are you exlicitly closing the connections to the database? before
> disposing of the objct you need to call sql_connection.close
>
>
>
> Clement wrote:
> > hi,
> > i have an asp.net site and is using SQL Server 2k. i realize the
> > aspnet_wp.exe memory usage keep growing and i will receive an
error
for
the
> > pages that call the sql connection. others page with no sql

connection is
> > fined.
> > At the time when i encounter the error, i check the memory usage
for > >
> > aspnet_wp.exe = 60000kb
> > sqlmangr.exe = 40000kb
> >
> > at this time, if i terminated the aspnet_wp.exe from the task

manager, my
> > asp.net web site will back to normal and this problem will occurs

again
once
> > the memory usage is hit to above the same values i mention above.
> >
> > in my asp.net, i have several classes that have its own sqlconnection object
> > and at the end of code i always dispose the sqlcommand and

sqlconnection
> > object and it still doesn't help to resolve the problem.
> > from my log record, i can see this problem only arrise when performing the
> > sql query like sqlcommand.executereader or sqlcommand.executenonquery and
> > etc.
> >
> > Follwing is the spec for the software and hardware running the sql and > > asp.net
> > Software Spec
> > 1. .NetFramework 1.0 with SP2
> > 2. Win2k Server with SP3
> > 3. SQL Server 2000 with sp2
> >
> > Hardware spec.
> > 1. P4 Xeon processor
> > 2. 512MB Ram
> >
> > Please help!!!
> > Thanks
> > from clement
> >
> >
>



Nov 17 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by djc | last post: by
2 posts views Thread by DKode | last post: by
4 posts views Thread by Patrick Olurotimi Ige | last post: by
2 posts views Thread by Sidharth | last post: by
9 posts views Thread by jeungster | last post: by
3 posts views Thread by crazy420fingers | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.