sims.net on sql server 2008_windows 2003
Hi all my sims server is currently given me a load of grief, maxing the processor. Its on a Citrix xen virtual server with 4 vcpus and 4gb of RAM and it appears that this problem only really started to surface when we upgraded the sql install from sql 2005 to sql 2008. I am presuming that sql server 2008 is more resource hungry and i need to fine tune the performance.
Does anyone have any tips for ensuring best possible performance both from a sims point of view and a sql server 2008 point of view? i have ran through some maintenance tasks in sql server but to be honest its a bit of guess work at the moment..
Thanks in advance