I have had a virtual cloud server with [Storm on Demand for about two and a half years now. The server comes with 2 GB RAM, 1 CPU, 150 GB HD. You can see the specs [url=https://www.stormondemand.com/pricing/]here](http://www.stormondemand.com); it is the second one down.
I'm running a Drupal site. It's been going very well until now, but for the past few weeks, my Web server has hanged every single day just about, and often more than once per day. If not caught in time, the load of the server will rise to 40+. I and the host have tried everything we can think of, but nothing seems to be helping.
There don't seem to be any rogue modules or anything like that, and anyway it's been fine up to this point.
We're getting about 7,000 visits daily, as far as I can tell from my access logs.
I'm trying to avoid upgrading, but will as a last resort. No money is made the site so I'd prefer to keep it as low cost as possible. I've have to pay about $40 extra to upgrade.
So, firstly, can you think of anything I might be missing to alter? The host has been making most of the tweaks. They've optimized MySQL, Apache, PHP settings, and the whole nine yards. I've enabled anonymous caching in Drupal.
Secondly, do you think I need to upgrade? I'm really not sure how much 2 GB RAM and 1 core can accomplish, so perhaps it's just a matter of resources.
Your help is appreciated.