+ Post New Thread
Page 5 of 5 FirstFirst 12345
Results 61 to 64 of 64
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 ...
  1. #61
    jenny_urey's Avatar
    Join Date
    Nov 2007
    Location
    Home: Telford Office: Wolverhampton Work Travel: all over UK!
    Posts
    124
    Thank Post
    33
    Thanked 11 Times in 10 Posts
    Rep Power
    18
    Quote Originally Posted by creese View Post
    We have found lately that Sophos hogs the resources and SQL gets the blame.
    Sophos can be a pain though you can add exemptions to overcome this and prevent it running when you need to sort out reports

  2. #62
    jenny_urey's Avatar
    Join Date
    Nov 2007
    Location
    Home: Telford Office: Wolverhampton Work Travel: all over UK!
    Posts
    124
    Thank Post
    33
    Thanked 11 Times in 10 Posts
    Rep Power
    18
    Quote Originally Posted by Darylrese View Post
    Good Afternoon,

    Our school are having major problems since upgrading from SQL2005 to SQL2008. Users are reporting both SIMS and PARS are running VERY slowly. When running a simple report it can take upto 20mins or crashes out completely.

    The sims.ini and connect.ini are correct, the MIS Server is not under stain according to the performance manager in both windows and SQL studio 2008.

    The problem seems to be fairly random. Sometimes it runs ok and other times grinds to a halt. Users report even the quicker times are slower than they used to be with SQL2005.

    TASC who make PARS have spent several hours looking at the SQL database and server and can't find anything wrong with it. All patches / updates for both SIMS and PARS have been applied.

    Any ideas? Its driving us nuts!!!

    Thanks!
    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!

  3. #63

    Join Date
    Apr 2008
    Posts
    853
    Thank Post
    111
    Thanked 112 Times in 108 Posts
    Rep Power
    46
    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 03:52 PM. Reason: watch the language when ranting!

  4. #64
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63
    Quote Originally Posted by irsprint84 View Post
    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!

    Excelent Tips.

    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.

    Butuz
    Last edited by Butuz; 25th March 2011 at 02:19 PM.



SHARE:
+ Post New Thread
Page 5 of 5 FirstFirst 12345

Similar Threads

  1. SQL2008 Express Reboot Rule Fails
    By Rawns in forum Windows
    Replies: 0
    Last Post: 11th August 2010, 12:33 PM
  2. SIMS - SQL2005 > SQL2008 Migration Problem
    By RobFuller in forum MIS Systems
    Replies: 26
    Last Post: 24th March 2010, 11:39 PM
  3. sims slow to save data for some users
    By maark in forum MIS Systems
    Replies: 12
    Last Post: 2nd February 2010, 09:59 AM
  4. Help Please june Update + sql2008
    By woodham in forum MIS Systems
    Replies: 7
    Last Post: 6th July 2009, 04:26 PM
  5. Moodle - Slow when more than a few users are logged in
    By wesleyw in forum Virtual Learning Platforms
    Replies: 18
    Last Post: 21st September 2007, 03:34 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •