+ Post New Thread
Page 1 of 4 1234 LastLast
Results 1 to 15 of 57
MIS Systems Thread, SIMS gradually getting slower and slower... in Technical; Has anyone experienced any issues with SIMS recently where it will gradually get slower and slower until it just halts? ...
  1. #1
    Olliesaurus's Avatar
    Join Date
    Sep 2012
    Posts
    115
    Thank Post
    23
    Thanked 5 Times in 5 Posts
    Rep Power
    4

    SIMS gradually getting slower and slower...

    Has anyone experienced any issues with SIMS recently where it will gradually get slower and slower until it just halts?

    Let me set the scene,

    April 2013: New SIMS install, all running perfectly and nice and fast, 8GB RAM
    October 2013: Start seeing decrease in speed, namely on larger reports.
    November 2013: Capita suggest upgrading the RAM to 16GB, upgrade the server RAM to 24GB, restrict SQL to 16GB RAM, still slow speed on larger reports
    December 2013: Capita taking screenshots of RAM usage but still slow speed on larger reports

    A friend of mine is experiencing something a-like it, just wondered if there was something that I am doing glaringly wrong...

    Needless to say, very grumpy SIMS manager at the moment...

  2. #2

    Join Date
    Nov 2008
    Posts
    11
    Thank Post
    40
    Thanked 2 Times in 2 Posts
    Rep Power
    12
    We've had a very similar experience. When arrived this time last year sims was playing nicely on an 8GB single core VM, then gradually through the year (mainly after the spring update) larger reports have brought the server to its knees. During the summer we gave the VM 16GB and 3 more cores, but that made no difference. The pinnacle of this was running a change of holidays a couple of weeks ago, that took nearly ten hours to run. Not fun.

  3. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    We've had an issue that seems to have started with the summer update whereby clicking anything in course manager results in an egg timer and 5-10 minute wait. Local support said we need more RAM, which helped a little but not much. The Autumn census was a nightmare!

  4. #4
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,486
    Thank Post
    37
    Thanked 490 Times in 422 Posts
    Rep Power
    110
    Same here, SIMS is getting slower and slower at the moment

  5. #5
    mrbios's Avatar
    Join Date
    Jun 2007
    Location
    Stroud, Gloucestershire
    Posts
    2,459
    Thank Post
    349
    Thanked 256 Times in 211 Posts
    Rep Power
    98
    Not sure if it's related but i had performance issues up until i ran a patch which reindexed all the tables in the sims database.

    Might be worth asking for, can't hurt to run it even if it doesn't fix it.

  6. #6
    Olliesaurus's Avatar
    Join Date
    Sep 2012
    Posts
    115
    Thank Post
    23
    Thanked 5 Times in 5 Posts
    Rep Power
    4
    I have run that reindexing patch not long ago, worked alright for the morning then went back to slowness, I have been given a patch relating to Discovery, however it apparently does some "internal maintenance", I just nodded and accepted, running tonight.

    It does look like its an issue with SIMS as opposed to peoples servers, which was my worry, it is definitely a relief to know that others are experiencing the same issue that I am.

    Fingers crossed the Autumn update will address some of these issues, not all that confident that it will though...

  7. #7

    Join Date
    Mar 2009
    Location
    Cambridge
    Posts
    32
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    SIMS doesn't manage the SQL log files for you... Might be worth taking a look there.

  8. #8
    Olliesaurus's Avatar
    Join Date
    Sep 2012
    Posts
    115
    Thank Post
    23
    Thanked 5 Times in 5 Posts
    Rep Power
    4
    Quote Originally Posted by rj_mayer View Post
    SIMS doesn't manage the SQL log files for you... Might be worth taking a look there.
    Yeah, I shrunk the logs but still slow :/

    Will see what Autumn brings.

  9. #9
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,207
    Thank Post
    451
    Thanked 174 Times in 171 Posts
    Blog Entries
    3
    Rep Power
    64
    I'm having the same issue, very noticable with reports where today we are back at the situation we were 2 months ago where all reports say they are going to take a long time to run.

    Going to try a server restart tonight, if that doesn't help then it's the reindex patch again I guess!

    Edit: Server rebooted, reindexing patch applied - still can't run any reports wihtout it saying it's going to take a long time
    Last edited by Cache; 2nd December 2013 at 09:29 PM.

  10. #10
    hallb15's Avatar
    Join Date
    Jan 2012
    Location
    Leeds
    Posts
    405
    Thank Post
    462
    Thanked 231 Times in 149 Posts
    Rep Power
    74
    We're getting the same thing here too.

  11. #11
    danrhodes's Avatar
    Join Date
    Sep 2008
    Location
    Wath Upon Dearne
    Posts
    1,513
    Thank Post
    157
    Thanked 181 Times in 150 Posts
    Rep Power
    67
    Were having the same issues also, I manage Sims at a few sites and its same all over, very sluggish even loading. We run sims at one site on Dual 8 Core Xeon 48GB Ram and its still slow What ever we have tried seems to make no difference.

  12. #12

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,958
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    I'm convinced the problem is to do with indexes and statistics. The reindex patch doesn't update the stats.

    Hint to make marks run faster: att_mark_normalised could do with some more indexes to stop RID/bookmark lookups. e.g. create an NCI on att_mark_normalised (session_start) INCLUDE person_id, mark, session_number.



    I've noticed an improvement after running the following maintenance plan. Also, if you do this regularly the 100% fill factor is less of an issue.

    Try setting up a maintenance plan to rebuild (not reorganise) your indexes.

    Usual disclaimers, at your own risk and so on. If you're not confident with this procedure, do not proceed.


    Start SQL Management studio
    Expand 'Management'
    Right-click 'Maintenance Plans'
    Click 'Maintenance Plan Wizard'

    Name you plan something like 'Reindex SIMS'.
    On the same screen, click the 'Change' button next to Schedule
    Set a suitable schedule (Frequency should be daily, or weekly if you prefer, at a time that fits your setup - choose a quiet time at night.)

    On the next screen,
    Under 'Select Maintenance Tasks', check the 'Reuild Indexes' box

    In the 'Define Reuild Index task' window, choose your SIMS database(s) to reindex.
    For 'object', choose 'tables and views'
    On the same window, check the box that says 'sort results in tempdb', keep the box that says 'keep index online...' unchecked.

    Optionally, choose to write a report to file.

    Bask in the inevitable glory of a supefast system.*


    *This step optional, and not guaranteed.



    If you try this, please post back with your results, whether successful or not.
    Last edited by jinnantonnixx; 6th December 2013 at 05:27 PM.

  13. Thanks to jinnantonnixx from:

    simpsonj (1st May 2014)

  14. #13

    Join Date
    Nov 2013
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    We have had it reported 3 times in the last weeks where reports just freeze when they normally take 20 seconds to run. If left they normally generate after about 30 minutes or restarting the machine seems to clear it.

  15. #14
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86
    Yep similar experience here, are Capita listening to this?

    I reported this in my server benchmarking thread a while ago.

  16. #15

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,318
    Thank Post
    35
    Thanked 351 Times in 237 Posts
    Rep Power
    78
    We have taken in some school's data to investigate particular cases of the reporting engine running slowly so that we can improve specific cases.

SHARE:
+ Post New Thread
Page 1 of 4 1234 LastLast

Similar Threads

  1. [SIMS] SIMS .net Default Username and Password?
    By jmahone in forum MIS Systems
    Replies: 5
    Last Post: 7th March 2013, 07:43 PM
  2. Vista getting slower and slower then freezing...
    By boomam in forum Windows Vista
    Replies: 5
    Last Post: 23rd October 2008, 03:23 PM
  3. Can't get mysql and PHP to play together on IIS
    By dagza in forum Web Development
    Replies: 5
    Last Post: 20th January 2008, 03:38 PM
  4. Replies: 5
    Last Post: 16th December 2007, 06:26 PM
  5. Replies: 2
    Last Post: 25th October 2007, 11:54 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
  •