This is a great article on why having or adding more memory won’t fix your Out of Memory Exception. Bottom line.. on a 32bit server you’re site will crash when it hits between 600MB and 800MB. The amount varies based on what else is going on with the machine. The solution? Basically, you have to upgrade to a 64bit OS or re-write your application.
Why adding more memory won’t fix your Out of Memory error by Edge
Copied from the article directly, in case it ever goes down.
Here an interesting case. Consider there 2 scenarios:
Both are running the same website, both have the same amount of users connected.
Now imagine this website has a page to upload pictures, just like any regular photo-album website.
For some reason, at some point the users complain that they see an error page indicating out of memory error.
So, you wonder: How come? they are just uploading a photo to my website, and I still have plenty of memory in my server anyway.
Anyhow, you stop thinking about this and go for the easiest, quick and dirty solution: If the system tells me that my computer does not have enough memory then I just need to add more memory. Right?
And guess what? you still will get the error message.
That's a very common mistake. Having a machine with 10GB of memory does not mean you will have 10GB of memory available. I explain.
It does not matter if your computer or server has 512 MB, 1 GB, 2 GB, 4 GB or 8 GB of RAM. If your machine is a 32-bit machine it will only be able to see/manage 4 GB. That's mathematics, that's life, that's the way things are and you can't do nothing about it. A 32-bit machine can not do more than that.
Additional memory may increase your system performance, but it won't increase the memory availability. Sure your computer will use less the hard disk for swapping operations and will be able put more stuff in memory and start some programs faster, but 4GB is the limit; after this point the memory management module will start doing disk swap and to use the famous page file.
And here comes more bad news: Your Windows system on a 32-bit machine requires 2 GB allocated only for it.
So, if you have 4 GB installed, effectively you will have 2 GB only for applications; your windows will be using alone 2 GB.
So, what does out of memory means?
Well, according to some people at Microsoft, this limit for an average configuration is reached between 600 MB and 800 MB of utilization. That 800 number is NOT A RULE, is a baseline. Generally speaking the largest majority of configurations with website, .NET and SQL Server database might have a problem around this point. Of course, this can vary from system to system...as a matter of fact a system can be out of memory at just 600 MB.
Yes, it does sounds crazy. You look so happy now that you just bought a 4GB RAM notebook and your computer is breaking with just 800MB, hun?
Here is another point for you. Have you ever seen someone bragging that he/she bought a 10-megapixel camera and now he/she believes their pictures are going to be better because of this?
Well, guess what? Just like the number of megapixels in a camera box does not have much to do with picture quality, RAM memory does not have much to do with hard disk space.
That's a common mistake: People buy RAM as if they were buying a hard disk.
RAM usage needs to me continuous, unlike hard disk. A simple 5MB Microsoft Word document when saved in a hard disk can be split up in hundreds of pieces; When you open this file in memory, the RAM requires those 5MB to be allocated continuously.
Can you see now the reason for the 'out of memory' message?
Yes, it really means 'there is not enough continuous memory to place that file in memory'. Your system might have 2GB of RAM but unfortunately it might be too busy with stuff running and there is no enough continuous memory to put the picture you are uploading.
Yeah, you can not do much but you can buy a 64-bit machine then when you add more memory you can really use it more efficiently. And yes, we have Microsoft Windows systems for 64-bit machines.
If you do not want to buy a new system of upgrade you current server to a better version then you should think other solutions in the business process, such as to avoid users upload pictures with more than 1 MB in size to be uploaded.