+ Post New Thread
Page 2 of 4 FirstFirst 1234 LastLast
Results 16 to 30 of 57
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 ...
  1. #16
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,077
    Thank Post
    812
    Thanked 353 Times in 277 Posts
    Blog Entries
    60
    Rep Power
    280
    Quote Originally Posted by LosOjos View Post
    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!
    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.

  2. Thanks to CAM from:

    LosOjos (6th December 2013)

  3. #17

    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
    Quote Originally Posted by CAM View Post
    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.
    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!

  4. #18
    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
    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.

  5. #19
    MACIT's Avatar
    Join Date
    Sep 2008
    Posts
    51
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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.

  6. #20

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,954
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    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.

    Quote Originally Posted by jinnantonnixx View Post
    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.

  7. Thanks to jinnantonnixx from:

    zag (20th December 2013)

  8. #21

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    @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.

  9. #22

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,954
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    Quote Originally Posted by matt40k View Post
    @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.
    Never heard of it - but it sounds good. Any links? This stuff should be wiki-fied.

    The queries involving marks are crying out for more indexes.
    Last edited by jinnantonnixx; 20th December 2013 at 11:27 AM.

  10. #23

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    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).

  11. #24
    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
    Hmm it wont let me run the Maintenance plan for some security reason.

    Is this worth going through the hassle of setting this up?

  12. #25

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,954
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    Quote Originally Posted by zag View Post
    Hmm it wont let me run the Maintenance plan for some security reason.

    Is this worth going through the hassle of setting this up?
    I would say so. Our reports were practically unusable until I did this. Now they're back to normal. Not brilliant, but normal.

    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.

  13. #26

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,954
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    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.

  14. #27

    Join Date
    Dec 2005
    Posts
    524
    Thank Post
    34
    Thanked 87 Times in 77 Posts
    Rep Power
    39
    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)

  15. #28
    spr
    spr is offline

    Join Date
    Jan 2014
    Location
    Blackpool
    Posts
    5
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    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

  16. #29
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,077
    Thank Post
    812
    Thanked 353 Times in 277 Posts
    Blog Entries
    60
    Rep Power
    280
    Quote Originally Posted by LosOjos View Post
    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!
    I totally missed this reply! Sorry.

    LA support team ran a patch or something to fix it for us.

  17. #30

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,954
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    Quote Originally Posted by spr View Post
    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
    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.

SHARE:
+ Post New Thread
Page 2 of 4 FirstFirst 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
  •