We are currently running on 4 core server with 8GB memory and are finding that since upgrading to Magento the SQL server side seems a little slow.
From what I can see, I am uploading my week figures for load, disk, cpu and memory, but do not understand all the numbers. I understand this as being heavy on disk, light on CPU and I am guessing the LOAD is high.
Based on this what should I do, I have the following options
Get a larger server 6 core / 8 core
Lots more memory 12GB , 24GB
I am currently on managed server, and am considering Dedicated with root access as I cannot install APC or memcached , change MySQL server settings or move / change Apache.
My biggest issue is around the admin side were the longest running grid is the SALES orders grid which takes a good 20 seconds to load every time an order comes in etc.... so guessing this is SQL server related / CPU related. Everything else runs fine, including the front end.
Any advise would be great