473,326 Members | 2,134 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

aspnet_wp process 100%

Hello,

We are experiencing some issues with the aspnet_wp process on our live
servers. The problems are intermittent and we cannot reproduce it on our dev
and test servers.

Currently around twice a day the aspnet_wp process takes 100% of the cpu and
causes the whole website to come to a stand still. We then have to end the
process for the website to become useable. Once the aspnet_wp process
recycled itself and in the event logs it mentioned that it had recycled
itself due to a deadlock. Unfortunately we haven't been able to wait until
the aspnet_wp recycles itself because the live website comes to a standstill
so can't say for definite if the subsequent problems are due to a deadlock
too. We have tried to look through the weblogs for around the time the aspnet
process hangs but almost everything has a high time taken value and some
pages (normally those that display a lot of info) have high sc-bytes and
cs-bytes.

Some information that we can give is that we recently had a problem with a
reporting services report which returned a lot of data (10s of thousands of
records). When executing and displaying this report through the website it
caused the whole website to hang. I think the memory of the aspnet process
started to increase. Actually this problem is quite common on this website in
that it has a lot of data to display on some pages. For example one page
tries to display 10s of thousands of rows from the database. The page has
been configured to use minimal viewstate/session and to use paging but
because it still retrieves this large amount of data from the database and
process/store it, the memory usage of the process increases. Is this a
separate issue from the 100% CPU issue? Or does high memory usage of the
aspnet_wp causes 100% CPU too?

We have also experienced some intermittent general network errors - could
this cause the problems too?

Also if anybody could direct us into a good way to display lots of
information then it would be really appreciated. A lot of the information is
displayed in datagrids (which have sorting and paging) but unforunately we
haven't been able to think of a way to reproduce paging so that we only
retrieve that page's amount for the database. So if we have 100 records
displayed on the website for a datagrid page we would like to only retrieve
those 100 records from the database. If the sort expression changes then we
would have to reevaluate and return the 100 records. The only way we can
think of doing this is via dynamic SQL - but I think this is normally not
advised? The other way we thought was to not allow sorting and to store the
results from the SQL into temporary tables. Then we could return the 1st,
2nd, 3rd,... hundred rows from this temp table? - but we lose the sorting
functionality and I don't know how this would affect the performance because
we are using temp tables and many users could be accessing this at the same
time.

Any advice on the above issues would be much appreciated.

Thanks.
Sidharth

P.S. using Framework 1.1, Enterprise library (for logging and data access),
Sql Server 2000 & Reporting Services.
Nov 19 '05 #1
2 2164
Hello sidharth ,

Are you using crystal reports come with visual studio ? There was a bug with
crystal reports causing memory leak and high cpu usage under heavy web site
load.We submited bug to crystal reports but as far as i know no action taken
in that time.So we have changed the tool.

To find what causes this , what we have done was debugging aspnet_wp process
while it is running in the production enviroment.Because we couldn't
succesffuly repeat the error in our test enviroment..In our case after
simulteneus calls to one of the crystal reports' dll's was causing the
error.You can search msnd for how to debug aspnet_wp process.

Regards,
Ersin

"Sidharth" <Si******@discussions.microsoft.com> wrote in message
news:D5**********************************@microsof t.com...
Hello,

We are experiencing some issues with the aspnet_wp process on our live
servers. The problems are intermittent and we cannot reproduce it on our dev and test servers.

Currently around twice a day the aspnet_wp process takes 100% of the cpu and causes the whole website to come to a stand still. We then have to end the
process for the website to become useable. Once the aspnet_wp process
recycled itself and in the event logs it mentioned that it had recycled
itself due to a deadlock. Unfortunately we haven't been able to wait until
the aspnet_wp recycles itself because the live website comes to a standstill so can't say for definite if the subsequent problems are due to a deadlock
too. We have tried to look through the weblogs for around the time the aspnet process hangs but almost everything has a high time taken value and some
pages (normally those that display a lot of info) have high sc-bytes and
cs-bytes.

Some information that we can give is that we recently had a problem with a
reporting services report which returned a lot of data (10s of thousands of records). When executing and displaying this report through the website it
caused the whole website to hang. I think the memory of the aspnet process
started to increase. Actually this problem is quite common on this website in that it has a lot of data to display on some pages. For example one page
tries to display 10s of thousands of rows from the database. The page has
been configured to use minimal viewstate/session and to use paging but
because it still retrieves this large amount of data from the database and
process/store it, the memory usage of the process increases. Is this a
separate issue from the 100% CPU issue? Or does high memory usage of the
aspnet_wp causes 100% CPU too?

We have also experienced some intermittent general network errors - could
this cause the problems too?

Also if anybody could direct us into a good way to display lots of
information then it would be really appreciated. A lot of the information is displayed in datagrids (which have sorting and paging) but unforunately we
haven't been able to think of a way to reproduce paging so that we only
retrieve that page's amount for the database. So if we have 100 records
displayed on the website for a datagrid page we would like to only retrieve those 100 records from the database. If the sort expression changes then we would have to reevaluate and return the 100 records. The only way we can
think of doing this is via dynamic SQL - but I think this is normally not
advised? The other way we thought was to not allow sorting and to store the results from the SQL into temporary tables. Then we could return the 1st,
2nd, 3rd,... hundred rows from this temp table? - but we lose the sorting
functionality and I don't know how this would affect the performance because we are using temp tables and many users could be accessing this at the same time.

Any advice on the above issues would be much appreciated.

Thanks.
Sidharth

P.S. using Framework 1.1, Enterprise library (for logging and data access), Sql Server 2000 & Reporting Services.

Nov 19 '05 #2
Hello Ersin,

Thanks for your response. We did originally use Crystal but have moved to RS
around a year ago. We didn't actually see these problems with Crystal.

I'll ask around to see if we are allowed to debug on the live server.

Thanks for your help.
Sidharth

"Ersin Gençtürk" wrote:
Hello sidharth ,

Are you using crystal reports come with visual studio ? There was a bug with
crystal reports causing memory leak and high cpu usage under heavy web site
load.We submited bug to crystal reports but as far as i know no action taken
in that time.So we have changed the tool.

To find what causes this , what we have done was debugging aspnet_wp process
while it is running in the production enviroment.Because we couldn't
succesffuly repeat the error in our test enviroment..In our case after
simulteneus calls to one of the crystal reports' dll's was causing the
error.You can search msnd for how to debug aspnet_wp process.

Regards,
Ersin

"Sidharth" <Si******@discussions.microsoft.com> wrote in message
news:D5**********************************@microsof t.com...
Hello,

We are experiencing some issues with the aspnet_wp process on our live
servers. The problems are intermittent and we cannot reproduce it on our

dev
and test servers.

Currently around twice a day the aspnet_wp process takes 100% of the cpu

and
causes the whole website to come to a stand still. We then have to end the
process for the website to become useable. Once the aspnet_wp process
recycled itself and in the event logs it mentioned that it had recycled
itself due to a deadlock. Unfortunately we haven't been able to wait until
the aspnet_wp recycles itself because the live website comes to a

standstill
so can't say for definite if the subsequent problems are due to a deadlock
too. We have tried to look through the weblogs for around the time the

aspnet
process hangs but almost everything has a high time taken value and some
pages (normally those that display a lot of info) have high sc-bytes and
cs-bytes.

Some information that we can give is that we recently had a problem with a
reporting services report which returned a lot of data (10s of thousands

of
records). When executing and displaying this report through the website it
caused the whole website to hang. I think the memory of the aspnet process
started to increase. Actually this problem is quite common on this website

in
that it has a lot of data to display on some pages. For example one page
tries to display 10s of thousands of rows from the database. The page has
been configured to use minimal viewstate/session and to use paging but
because it still retrieves this large amount of data from the database and
process/store it, the memory usage of the process increases. Is this a
separate issue from the 100% CPU issue? Or does high memory usage of the
aspnet_wp causes 100% CPU too?

We have also experienced some intermittent general network errors - could
this cause the problems too?

Also if anybody could direct us into a good way to display lots of
information then it would be really appreciated. A lot of the information

is
displayed in datagrids (which have sorting and paging) but unforunately we
haven't been able to think of a way to reproduce paging so that we only
retrieve that page's amount for the database. So if we have 100 records
displayed on the website for a datagrid page we would like to only

retrieve
those 100 records from the database. If the sort expression changes then

we
would have to reevaluate and return the 100 records. The only way we can
think of doing this is via dynamic SQL - but I think this is normally not
advised? The other way we thought was to not allow sorting and to store

the
results from the SQL into temporary tables. Then we could return the 1st,
2nd, 3rd,... hundred rows from this temp table? - but we lose the sorting
functionality and I don't know how this would affect the performance

because
we are using temp tables and many users could be accessing this at the

same
time.

Any advice on the above issues would be much appreciated.

Thanks.
Sidharth

P.S. using Framework 1.1, Enterprise library (for logging and data

access),
Sql Server 2000 & Reporting Services.


Nov 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Luther Miller | last post by:
I have a server setup that is dedicate to providing a "proxy" by exposing a web service that calls methods in a 3rd party ActiveX control and then returns the results. Sometimes, the aspnet_wp work...
5
by: Ken Barrett | last post by:
I apologize in advance for cross-posting, but I have noted that others have experienced similar issues and was hoping that someone could help. Briefly, I am working on an ASP.NET content...
2
by: Cynthia | last post by:
Hi, I have a two Load Balanced servers running MS Content Mangement Server 2002. Both servers runs asp.net applications. On one of the nodes, aspnet_wp.exe process behaves as following: -...
0
by: Christopher | last post by:
Hi there, several of our ASP.NET apps started to slow down recently quite a bit and we noticed the aspnet_wp.exe process taking up 100% CPU time. I have heard a little on the hotfix available for...
3
by: Jason Hinsperger | last post by:
We have built an ADO.NET data provider which is causing a problem in aspnet applications, in the VS.NET development environment only The first time the aspnet application is run, everything works...
3
by: Luk | last post by:
Hi, we have got a problem with asp.net and we don't know what to do Usually aspnet_wp.exe under medium/high load uses a maximum of 40% cpu power. Suddently even when requests are not so high it...
1
by: O'O | last post by:
There are many asp.net applications running on my server. Sometimes aspnet_wp process consumes 100% of processor time. I want to find out, which application causes this. There is probably a bug in...
2
by: Marcin Belczewski | last post by:
I have a problem with aspnet_wp.exe on my Windows XP. When I start any of my web applications, webservices or even try to create asp.net project under vs.net - aspnet_wp.exe process starts -...
2
by: ruca | last post by:
Hi gurus, Can anyone tell me please when I really must setup the value of memory that aspnet_wp or w3wp must use in IIS server machine? What I mean is that we have clients that have diferent...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.