My server was on its A*53 for last 2 days and ran out of ideas! capita guy came last august to do upgrade and did rubbish job but.. just done the following things and server has been fastest its ever been!
sql management studio -> properties of either sims/ ccfms database -> options -> recovery mode _> set it to simple for both
Reduce log files
also make sure named pipes is enabled as guy who installed set to disabled!
1. Make sure you are not using SQL 2008 Express or SIMS will only be able to use One CPU and 4Gb Ram.
Also - ensure you have as many CPUs as you can (my sims server gets 4) and preferably ensure you are running Windows 2003 64 bit so you can use 8GB or more of RAM (SWL will cache the database in RAM speeding everything up loads). Preferably don't use RAID 5 either as it has very poor write performance. Raid 10 would be better.
We dont seem to have performance issue (4cpu, 8Gb RAM, Triple Parity Raid) and all of our teachers use the little home page graphs.