MIS Systems Thread, SQL2008 VERY SLOW FOR ALL USERS in Technical; Originally Posted by creese
We have found lately that Sophos hogs the resources and SQL gets the blame.
Sophos can ...
25th March 2011, 12:21 PM #61
Sophos can be a pain though you can add exemptions to overcome this and prevent it running when you need to sort out reports
Originally Posted by creese
25th March 2011, 12:24 PM #62
Are you sorted yet? with regards to reports, did you know you can schedule reports to run via PARS which will automatically send themselves to the specified staff - especially good for attendance / behaviour reports for heads year/house/curriculum leaders.... all via System Management > Automation Job. if you need to know more on this let us know as cant really say more on here. Will save time and hopefully overcome some of that thumb twiddling!
Originally Posted by Darylrese
25th March 2011, 12:45 PM #63
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!
Last edited by vikpaw; 27th March 2011 at 02:52 PM.
Reason: watch the language when ranting!
25th March 2011, 01:09 PM #64
Originally Posted by irsprint84
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.
Last edited by Butuz; 25th March 2011 at 01:19 PM.
By Rawns in forum Windows
Last Post: 11th August 2010, 11:33 AM
By RobFuller in forum MIS Systems
Last Post: 24th March 2010, 10:39 PM
By maark in forum MIS Systems
Last Post: 2nd February 2010, 08:59 AM
By woodham in forum MIS Systems
Last Post: 6th July 2009, 03:26 PM
By wesleyw in forum Virtual Learning Platforms
Last Post: 21st September 2007, 02:34 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)