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?
2nd December 2013, 11:52 AM #1
- Rep Power
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...
2nd December 2013, 02:42 PM #2
- Rep Power
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.
2nd December 2013, 02:53 PM #3
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!
2nd December 2013, 03:17 PM #4
Same here, SIMS is getting slower and slower at the moment
2nd December 2013, 03:49 PM #5
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.
2nd December 2013, 04:15 PM #6
- Rep Power
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...
2nd December 2013, 07:35 PM #7
- Rep Power
SIMS doesn't manage the SQL log files for you... Might be worth taking a look there.
2nd December 2013, 07:39 PM #8
- Rep Power
Yeah, I shrunk the logs but still slow :/
Originally Posted by rj_mayer
Will see what Autumn brings.
2nd December 2013, 08:53 PM #9
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.
5th December 2013, 11:10 AM #10
We're getting the same thing here too.
6th December 2013, 11:06 AM #11
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.
6th December 2013, 11:31 AM #12
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
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.
Thanks to jinnantonnixx from:
6th December 2013, 12:51 PM #13
- Rep Power
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.
6th December 2013, 12:57 PM #14
Yep similar experience here, are Capita listening to this?
I reported this in my server benchmarking thread a while ago.
6th December 2013, 01:20 PM #15
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.
By jmahone in forum MIS Systems
Last Post: 7th March 2013, 07:43 PM
By boomam in forum Windows Vista
Last Post: 23rd October 2008, 03:23 PM
By dagza in forum Web Development
Last Post: 20th January 2008, 03:38 PM
Last Post: 16th December 2007, 06:26 PM
By EduTech in forum Gaming
Last Post: 25th October 2007, 11:54 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)