Not enough storage...

The lines in question load a database recordset into an array for better performance.

This error suggests that the web server you are using has run out of resources and doesn't have sufficient memory.

This shouldn't happen and is a indication of an overloaded web server, you should demand that your web host either upgrades the web server you are on or moves your site to a server with less load. If they don't you should look for a new web host.

VPS is a load of crap that web host use to get more $$ out of you.

You are probally on the same server which still doesn't have enough resources.

What a host does when they say VPS (virtually private server) is on IIS 6 you can place a site in it's own Application Pool on the web server (takes less than 1 minutes to do). This can be good as other sites on the server are less likely to interfere with your own site if they crash the app pool (very unlikely on IIS 6 anyway). However, having another application pool will mean the server uses far more memory and resources, and on a server which already doesn't have enough memory or resources all this will do is make the problem worse.

I just hope they didn't charge you any money for this.

With servers being as cheap as they are now, you should never have low resources issues whereby your host sticks to many sites on one server, and changing your site to use it's own app pool (what they call a VPS account) on a server which is already overloaded is not something that should be done, unless you are sticking an extra 150-300Mb of memory in the server for each VPS account (this is how much I find an app pool uses when not recycled for 24 hours on a moderately busy web site). It looks like all your web host cares about is $$ and it's time to find a new web host.

There isn't a way to monitor your ASP to see if that uses to many resources, just check that any objects you create are destroyed as soon as they are no longer needed, and you close all recordsets.



Edited by -boRg- - 08 August 2006 at 11:29am