aspnet_wp.exe taking up lots of memory

[djc]

the aspnet_wp.exe process in taking up lots of memory. Right now just the
one main page loads and imediately goes to the top of the memory usage list
with around 32MB of memory usage. The page only contains 1 datagrid that IS
using default paging and sorting capabilities. I am using 2 viewstate
variables to keep track of field and direction info for sorting so that the
columns sort asc then desc on second click etc... As far as the data for the
datagrid goes its not much. Only about 25 records or so total from an
MSDE2000 database running on the same machine.

1) any general ideas as to why so much memory is being used right off the
bat?

2) first page load is pretty slow. I know thats when it gets compiled and
the first page load should be slower than the rest but I think I'm
experiencing much to long of a delay for whats on the page. Up to 20 seconds
to load on first time?

3) I assume 1 of 2 things. There is a patch out for the aspnet worker
process that I need or I'm programming wrong. or both. I am new to
asp.net/vb.net and could use some direction on how 'housekeeping' has
changed. Using VB for other things I was very used to always setting my
object variables = Nothing but with .net I'm not sure which items need this
and the appropriate way to do it? .dispose? =nothing? both?

4) more ado.net specific but along the same lines as 3) above: when using a
dataAdapter to fill a datatable (using DataAdapter.Fill(DataTable)) do I
need to explicitly close anything besides the connection object?

any info is appreciated. Thanks.

[Kevin Spencer]

32MB of memory is a lot? A gigabyte is 1,024 megabytes. Most servers have
anywhere from 2 - 4 gigabytes of RAM.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"djc" <no***@nowhere.com> wrote in message
news:Of**************@TK2MSFTNGP15.phx.gbl...

the aspnet_wp.exe process in taking up lots of memory. Right now just the
one main page loads and imediately goes to the top of the memory usage list with around 32MB of memory usage. The page only contains 1 datagrid that IS using default paging and sorting capabilities. I am using 2 viewstate
variables to keep track of field and direction info for sorting so that the columns sort asc then desc on second click etc... As far as the data for the datagrid goes its not much. Only about 25 records or so total from an
MSDE2000 database running on the same machine.

1) any general ideas as to why so much memory is being used right off the
bat?

2) first page load is pretty slow. I know thats when it gets compiled and
the first page load should be slower than the rest but I think I'm
experiencing much to long of a delay for whats on the page. Up to 20 seconds to load on first time?

3) I assume 1 of 2 things. There is a patch out for the aspnet worker
process that I need or I'm programming wrong. or both. I am new to
asp.net/vb.net and could use some direction on how 'housekeeping' has
changed. Using VB for other things I was very used to always setting my
object variables = Nothing but with .net I'm not sure which items need this and the appropriate way to do it? .dispose? =nothing? both?

4) more ado.net specific but along the same lines as 3) above: when using a dataAdapter to fill a datatable (using DataAdapter.Fill(DataTable)) do I
need to explicitly close anything besides the connection object?

any info is appreciated. Thanks.

[djc]

32MB does seem like a lot to me for what I described. This is *not* a server
but simply a desktop machine I'm using to learn on. I am fully aware of
typical server hardware. If you look at my post you will see I am describing
a very simple page that I wouldn't expect to create more than a few MBs
worth of memory usage. I could be wrong... thats why I'm asking.

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ua**************@TK2MSFTNGP15.phx.gbl...

32MB of memory is a lot? A gigabyte is 1,024 megabytes. Most servers have
anywhere from 2 - 4 gigabytes of RAM.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"djc" <no***@nowhere.com> wrote in message
news:Of**************@TK2MSFTNGP15.phx.gbl...

the aspnet_wp.exe process in taking up lots of memory. Right now just the one main page loads and imediately goes to the top of the memory usage list

with around 32MB of memory usage. The page only contains 1 datagrid that

IS

using default paging and sorting capabilities. I am using 2 viewstate
variables to keep track of field and direction info for sorting so that

the

columns sort asc then desc on second click etc... As far as the data for

the

datagrid goes its not much. Only about 25 records or so total from an
MSDE2000 database running on the same machine.

1) any general ideas as to why so much memory is being used right off the bat?

2) first page load is pretty slow. I know thats when it gets compiled and the first page load should be slower than the rest but I think I'm
experiencing much to long of a delay for whats on the page. Up to 20

seconds

to load on first time?

3) I assume 1 of 2 things. There is a patch out for the aspnet worker
process that I need or I'm programming wrong. or both. I am new to
asp.net/vb.net and could use some direction on how 'housekeeping' has
changed. Using VB for other things I was very used to always setting my
object variables = Nothing but with .net I'm not sure which items need

this

and the appropriate way to do it? .dispose? =nothing? both?

4) more ado.net specific but along the same lines as 3) above: when

using a

dataAdapter to fill a datatable (using DataAdapter.Fill(DataTable)) do I
need to explicitly close anything besides the connection object?

any info is appreciated. Thanks.

[Kevin Spencer]

Okay, first, "a lot" is both a relative and a subjective term. It actually
means nothing in terms of quantity.

You're not describing the memory use of a single page. What you are
describing is the memory usage of the worker process, which is the worker
process for ASP.Net. If you think of the ASP.Net ISAPI as an application
running on the machine (which it is), the 32 MB of RAM represents for the
most part, the application itself, not a page instance, which is likely to
be a small percent of the memory being used.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"djc" <no***@nowhere.com> wrote in message
news:Oc**************@TK2MSFTNGP15.phx.gbl...

32MB does seem like a lot to me for what I described. This is *not* a server but simply a desktop machine I'm using to learn on. I am fully aware of
typical server hardware. If you look at my post you will see I am describing a very simple page that I wouldn't expect to create more than a few MBs
worth of memory usage. I could be wrong... thats why I'm asking.

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ua**************@TK2MSFTNGP15.phx.gbl...

32MB of memory is a lot? A gigabyte is 1,024 megabytes. Most servers have

anywhere from 2 - 4 gigabytes of RAM.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"djc" <no***@nowhere.com> wrote in message
news:Of**************@TK2MSFTNGP15.phx.gbl...

the aspnet_wp.exe process in taking up lots of memory. Right now just the one main page loads and imediately goes to the top of the memory usage

list

with around 32MB of memory usage. The page only contains 1 datagrid that IS

using default paging and sorting capabilities. I am using 2 viewstate
variables to keep track of field and direction info for sorting so

that

the

columns sort asc then desc on second click etc... As far as the data

for the

datagrid goes its not much. Only about 25 records or so total from an
MSDE2000 database running on the same machine.

1) any general ideas as to why so much memory is being used right off

the bat?

2) first page load is pretty slow. I know thats when it gets compiled and the first page load should be slower than the rest but I think I'm
experiencing much to long of a delay for whats on the page. Up to 20

seconds

to load on first time?

3) I assume 1 of 2 things. There is a patch out for the aspnet worker
process that I need or I'm programming wrong. or both. I am new to
asp.net/vb.net and could use some direction on how 'housekeeping' has
changed. Using VB for other things I was very used to always setting

my object variables = Nothing but with .net I'm not sure which items need

this

and the appropriate way to do it? .dispose? =nothing? both?

4) more ado.net specific but along the same lines as 3) above: when

using

a

dataAdapter to fill a datatable (using DataAdapter.Fill(DataTable)) do I need to explicitly close anything besides the connection object?

any info is appreciated. Thanks.

[djc]

ahh. I see. Thank you for the enlightenment. I appreciate it.

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ew**************@TK2MSFTNGP10.phx.gbl...

Okay, first, "a lot" is both a relative and a subjective term. It actually
means nothing in terms of quantity.

You're not describing the memory use of a single page. What you are
describing is the memory usage of the worker process, which is the worker
process for ASP.Net. If you think of the ASP.Net ISAPI as an application
running on the machine (which it is), the 32 MB of RAM represents for the
most part, the application itself, not a page instance, which is likely to
be a small percent of the memory being used.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"djc" <no***@nowhere.com> wrote in message
news:Oc**************@TK2MSFTNGP15.phx.gbl...

32MB does seem like a lot to me for what I described. This is *not* a server

but simply a desktop machine I'm using to learn on. I am fully aware of
typical server hardware. If you look at my post you will see I am

describing

a very simple page that I wouldn't expect to create more than a few MBs
worth of memory usage. I could be wrong... thats why I'm asking.

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ua**************@TK2MSFTNGP15.phx.gbl...

32MB of memory is a lot? A gigabyte is 1,024 megabytes. Most servers have anywhere from 2 - 4 gigabytes of RAM.

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"djc" <no***@nowhere.com> wrote in message
news:Of**************@TK2MSFTNGP15.phx.gbl...
> the aspnet_wp.exe process in taking up lots of memory. Right now just

the

> one main page loads and imediately goes to the top of the memory

usage list
> with around 32MB of memory usage. The page only contains 1 datagrid that IS
> using default paging and sorting capabilities. I am using 2 viewstate > variables to keep track of field and direction info for sorting so that the
> columns sort asc then desc on second click etc... As far as the data for the
> datagrid goes its not much. Only about 25 records or so total from an > MSDE2000 database running on the same machine.
>
> 1) any general ideas as to why so much memory is being used right off the

> bat?
>
> 2) first page load is pretty slow. I know thats when it gets

compiled

and

> the first page load should be slower than the rest but I think I'm
> experiencing much to long of a delay for whats on the page. Up to 20
seconds
> to load on first time?
>
> 3) I assume 1 of 2 things. There is a patch out for the aspnet

worker > process that I need or I'm programming wrong. or both. I am new to
> asp.net/vb.net and could use some direction on how 'housekeeping' has > changed. Using VB for other things I was very used to always setting

my > object variables = Nothing but with .net I'm not sure which items need this
> and the appropriate way to do it? .dispose? =nothing? both?
>
> 4) more ado.net specific but along the same lines as 3) above: when

using

a
> dataAdapter to fill a datatable (using DataAdapter.Fill(DataTable))

do I > need to explicitly close anything besides the connection object?
>
> any info is appreciated. Thanks.
>
>