We have upgraded to Sql 2008 Express and SIMS runs slow. We have SIMS InTouch and although Capita say that doesnt have an impact on SIMS overall performance I am sure it has degraded since InTouch was installed.
would it be beneficial to move from Sql Express to Sql Full? We have about 100 users and 800 students.
The SIMS Server is currently 2003 SP2 with 4GB and I am planning to put 2008 R2 on over the summer and up the RAM to 16GB.