ASPNet Worker Process up to 99% again

[Mark]

Hi - I have the old problem of my asp.net worker process shooting up to
99% - at which point my asp.net web app stops running.

My app reads rows from a sql server database table, and on the While
Read loop, appends certain information to a stringbuilder.

When a certain condition is met, a subroutine is called, which then
appends the stringbuilder text to a datatable.

The sqldatareader loop then continues and repeats until the end of the
records in the database.

I've added parts to write to a log file, within the loop, and it is just
stalling within the while read loop.

Is there a finite limit to the size of a datatable which would push the
aspnet worker process up to 99% ????

Thanks, Mark
*** Sent via Developersdex http://www.developersdex.com ***

[Rodrigo Firmino]

Hi Mark sees if in its event view exist an error with the description
below if to exist possibly can be that its MDAC is inferior version 2.7,
will be installs the new MDAC can be version 2.8 or 2.7 that it corrects
the error below.

To see the version of the MDAC, it opens the property of the archive
below and sees aversion of the archive "oledb32.dll".
C:\program files\comun files\System\Ole DB\oledb32.dll

Error event view: "aspnet_wp.exe (PID: 1580) was recycled because
memory consumption exceeded the 143 MB (60 percent of available RAM).
Event: 1001"

Att. Rodrigo

*** Sent via Developersdex http://www.developersdex.com ***