MIS Systems Thread, SIMS gradually getting slower and slower... in Technical; Originally Posted by LosOjos
We've had an issue that seems to have started with the summer update whereby clicking anything ...
6th December 2013, 02:01 PM #16
You have imported too many QANs into Course Manager. Get rid of the ones you don't need and only import the courses you are using. Mine ran like treacle as my predecessor imported every single QAN.
Originally Posted by LosOjos
Thanks to CAM from:
LosOjos (6th December 2013)
6th December 2013, 02:28 PM #17
I'll look in to that, don't suppose there's a guide anywhere? Not a part of the system I use but the timetabler will be very appreciative if it helps!
Originally Posted by CAM
6th December 2013, 06:53 PM #18
Just to update mine, after leaving it over night from doing the reindex patch, everything has been working reasonably well again since. However I know that in 2 months time this issue will definitely crop up again.
6th December 2013, 10:07 PM #19
Just to add my own experience to this, we also have been experiencing this decent into slowness even just logging into sims take twice as long as in used to. even though the server is eating up CPU's and Memory.
20th December 2013, 10:49 AM #20
Apologies for quoting myself, but I've seen a distinct benefit from regularly rebuilding the indexes (not reorganising/reindexing). This also creates fresh stats so that the query optimiser can generate better execution plans.
Originally Posted by jinnantonnixx
Thanks to jinnantonnixx from:
20th December 2013, 11:07 AM #21
@jinnantonnixx Did you ever get Bob Carswell document about maintenance plans? Basically it was a pretty word doc covering what your talking about but also some SIMS store procedures that are worth running regularly - like the valid memberships. It also covered other bits like renaming the sa account, testing your SQL backups and having a test system.
edit: forgot to say it also included recommend frequencies as well - ie this every month, that ever day, and this, this you only want to run yearly.. about this time of year.
Last edited by matt40k; 20th December 2013 at 11:08 AM.
20th December 2013, 11:12 AM #22
Never heard of it - but it sounds good. Any links? This stuff should be wiki-fied.
Originally Posted by matt40k
The queries involving marks are crying out for more indexes.
Last edited by jinnantonnixx; 20th December 2013 at 11:27 AM.
20th December 2013, 11:37 AM #23
Afraid not, still trying to find my copy he sent me, the joys of only having a 100mb mailbox He's retired now so I've got no hope of getting another copy to make it worse.
I think setting up a separate DW for reporting would be a start. At least then you wouldn't have to fight reporting speed (less joins\logic) vs operational speed (less writes).
17th January 2014, 09:41 AM #24
Hmm it wont let me run the Maintenance plan for some security reason.
Is this worth going through the hassle of setting this up?
17th January 2014, 10:15 AM #25
I would say so. Our reports were practically unusable until I did this. Now they're back to normal. Not brilliant, but normal.
Originally Posted by zag
The plan only takes five minutes to set up. Set it to run it over the weekend and see if there's an improvement on Monday. If you do try it, can you let us know the result?
Last edited by jinnantonnixx; 17th January 2014 at 12:53 PM.
17th January 2014, 12:40 PM #26
Important point - SQL Express edition doesn't have the SQL Agent and SSIS. Both of these are needed for maintenance plans.
It's possible to script this as TSQL script which can be run on the server or remotely, but this wouldn't be as trivial to set up.
Last edited by jinnantonnixx; 17th January 2014 at 12:56 PM.
17th January 2014, 12:47 PM #27
I am wondering if we could get an Ok you can do this from @PhilNeal ?
The script does sound like it would be helpful - but I really don't want to be doing anything with the sims database without capita oking it first.... (yes I'm a chicken... buck buck)
28th January 2014, 01:00 PM #28
- Rep Power
We also seem plagued by this , would also be curious to hear if the reindexing management plan as kindly posted by jinnantonnixx helps! Tempted to bite the bullet and give this a go anyway
28th January 2014, 01:15 PM #29
I totally missed this reply! Sorry.
Originally Posted by LosOjos
LA support team ran a patch or something to fix it for us.
28th January 2014, 01:40 PM #30
Well, before the reindexing plan was in place, SIMS reporting was like a sloth with gout. After the reindexing plan it's reasonable. Going on this, I'd say it's a worthwhile measure. If you do it, post back with your result either way.
Originally Posted by spr
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 3 users browsing this thread. (0 members and 3 guests)