Virtual Server 2003 Standard x86 Limits
Our SIMS server is running on a virtual server - Server 2003 standard R2 x86. (It was converted from a physical server). I have given it all the resources the OS supports i.e 4 cpu cores and 4Gb RAM.
We currently have a problem where CPU usage hits 100% on all cores and causes speed issues with SIMS because it's busy, especially around the time of year they do profiles and assman.
I can confirm that the activity is caused by SQL(SIMS) and not anything untoward.
I want to improve performance of the SIMS server. The virtual host has lots of spare resources (While the virtual SIMS server sits at 100% on all virtual cores only 5% real cpu is used on the host.)
Ideally I would like to create a new 2008 R2 server image and migrate SIMS over but I had a look and there are loads of SIMS integrated software that make this a bit tricky.
I know I can't upgrade 2003 x86 to 2008 R2 x64, but can I upgrade to x86 2003 enterprise to allow the use of more RAM and CPU cores?
If I do will I have to repair SQL 2008\SIMS etc or should it all just work?