We go from lightning quick to nearly unresponsive, anywhere from 30mins to several hours. I've been monitoring for the last 24hrs with the web host techs and we've identified the issue. It appears a rogue search index bot is hitting the site with millions of requests during this time.
Next steps:
I have installed a new tool that serves unknown search bots a blank white html page. I'm hopeful this is all we need and will boost our performance overall.
I have the ip address of the rogue bot and am investigating where it's from.
We are having some difficulties with the server. We've identified some memory problems and have placed an urgent request for a memory upgrade. Performance may be erratic until the upgrade is complete, there may be some downtime when the module is physically added to the server. Thanks for your patience, Sean
We had a good run for a while but I noticed issues again when I woke up this morning, have put it back to the techs. These issues can be hard to troubleshoot when intermittent but hopefully more progress today.
Site seems ok now that we're out of peak time, will allocate more resource to the site for the next peak and see how we go. Also, I am bringing in a Linux/Xenforo expert to do a full server optimisation. This should take place in the next 3 days.
Still going good, next test will be peak usage tomorrow and how we handle it. We've had some new settings put in tonight to take full advantage of the extra memory upgrade. This should more than triple our capability during peak load times.