The Situation:
1.I use asp.net with vb.net, thru' Visual studio.Net 2003 Professional.

2.The Application projects developed are Large Intranet web based.

3. The reports processed are on the Server where I extract data from Sql Server 2000 and store them in a Dataset and then pass on this data set to Crystal Reports.

The Problem:

Sometimes, I get an error: Memory overflow or Web Server is not available. In the event log, it shows asp.net with a remark that more than 60% of the memory is used.

I CAN NOT AVOID processing and generating large datasets as they CAN NOT BE BROKEN into small ranges of data.

The Server is with Intel Server motherboard SE7221 series, P4 3GHz, 2GB Main Memory. 2x 160gb HDD with enough space

Please guide as to what should be the course of action.

Regards,

Dilip Nagle

if possible try to use datareader which will increase performance if u r not doing any process on the data stored in dataset

dkautilya
[email protected]

How about getting more RAM?