IIS Error : System.OutOfMemory

we have a web app used by many users at work. this application is crashing most of time showing Out of Memory error on the user browser.
I can't troubleshoot it normally since it is intermittent issue. see attached the EventLog I have as a warning on this web app all times

Can someone help me resolve this or at least indicate me which software can trace this error if it is on the SQL Server side or on the IIS side

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

The error suggests that you are reading data from a database. How many records are being returned here? Did this outofmemory exception typically happen on this page?

How much RAM do you have on the server? Are you keeping datasets in session objects? How many concurrent users... Typically?
venmarcesAuthor Commented:
Well, I don't have the excat number of records being readed at this point. Well the appalication is mainly one ASPX page that users connect into and enter data .... we have more than 40 users that connect simultaneously on this web app

for the SQL server we have 16 GB of RAM and 4 CPU it is a VM ...

The problem is I don't even know if it is from SQL or from IIS server ... is there any explicit tool that can help to figure out this
Even in the absence of any specialised tools... 40 users loading one data capturing page on a 16GB RAM box should not be a problem at all.
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at _DisplayInfo.Page_Load(Object sender, EventArgs e)

Open in new window

OutOfMemory exception on DataAdapter.Fill that suggests a big dataset. The stack trace is your first tool. You need to gain better insights into what data is being loaded there. Number of records, and whether it really is necessary for a data entry page.

You can use the Windows Task Manager (Ctrl+Shft+Esc)  to see application behavior. That simple tool will show you memory and CPU usage by different processes. That might also help. You can look for w3wp.exe and sqlserver.exe.

There is also the SQL Server Profiler which comes with SQL Server standard upwards. It will help you see queries being run against the database. And how busy they are keeping SQL Server.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
venmarcesAuthor Commented:
thank you a lot
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.