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.
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.