+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 19
MIS Systems Thread, SIMS General Performance in Technical; We've started to notice a general degradation in performance from SIMS. The sims server which is old but more than ...
  1. #1

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,866
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461

    SIMS General Performance

    We've started to notice a general degradation in performance from SIMS. The sims server which is old but more than powerful enough is appearing to barely tick over - CPU, network, disk, activities are all minimal. Generally SIMS appears ok but at registration time when it's being hammered it's noticeable. When either of our SIMS/data administrators are running large reports it can sometimes be unusable for everyone else.

    Is there a particular place we should start looking to diagnose such issues? The SIMS server isn't exactly doing much other than SIMS, just a few LDAP queries for other services (that also pull from SIMS) but SQL performance diagnosis and the works aren't my strong point. Any pointers would be much appreciated

    Server is 2003 R2, dual Xeon E5420, 4GB RAM. As I type this, network utilisation is 0.13%. PF usage 3.34GB, CPU usage 1%.
    SQL Server is consuming 1.7GB RAM. (Large secondary.)

  2. #2
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Could be worth applying the classic re-index patch against the SIMS database. Also, what size is your SIMS.ldf file? Sometimes I've seen performance issues in schools where the SIMS database has slipped into full recovery mode and an upgrade has put it into full mode and the log file has just grown and grown.

    Also, have you thought about archiving previous attendance marks? We've done this in a few schools where there have been performance issues in Attendance and it's made a noticeable difference.
    Last edited by Rawns; 26th February 2013 at 02:40 PM.

  3. Thanks to Rawns from:

    synaesthesia (26th February 2013)

  4. #3

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    812
    Thank Post
    175
    Thanked 104 Times in 72 Posts
    Rep Power
    185
    Not helpful in your situation, but you do know that Capita aren't supporting 2003 from the Autumn release onwards don't you?

  5. Thanks to Jawloms from:

    synaesthesia (26th February 2013)

  6. #4

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,866
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461
    Fully aware. It's going 2012 probably Summer.

  7. #5

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    812
    Thank Post
    175
    Thanked 104 Times in 72 Posts
    Rep Power
    185
    Good.

    What size is your LDF file? There is a patch which will stop it growing above just a few MB, this can help.

  8. Thanks to Jawloms from:

    synaesthesia (26th February 2013)

  9. #6

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,866
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461
    errrr 12gb..... back soon! (It's been patched more times than Windows)
    Last edited by synaesthesia; 26th February 2013 at 02:59 PM.

  10. #7
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by synaesthesia View Post
    errrr 12gb..... back soon! (It's been patched more times than Windows)

    Bingo.

  11. #8

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,866
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461
    Back to a meg. Will keep an eye on that until we change it over.

    In the meantime, back to testing sims on 2012

  12. #9

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,866
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461
    On a slightly separate note, does anyone have any links to the SIMS server installation guidelines/documentation on Supportnet? I know it's there, and it needs more than google-fu to navigate one's way around their search!

  13. Thanks to synaesthesia from:

    Ghostgame (26th February 2013)

  14. #10
    Ghostgame's Avatar
    Join Date
    Jun 2012
    Location
    Ipswich
    Posts
    281
    Thank Post
    30
    Thanked 66 Times in 39 Posts
    Rep Power
    20
    Quote Originally Posted by synaesthesia View Post
    On a slightly separate note, does anyone have any links to the SIMS server installation guidelines/documentation on Supportnet? I know it's there, and it needs more than google-fu to navigate one's way around their search!
    Tell me about it.

  15. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Do you mean for the latest 2012?
    There is this for install SQL 2008 : KB94307
    To move db location : KB74632
    Make a test server : KB25354
    Migrate server : KB71383

  16. Thanks to vikpaw from:

    synaesthesia (27th February 2013)

  17. #12

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,866
    Thank Post
    574
    Thanked 998 Times in 770 Posts
    Blog Entries
    15
    Rep Power
    461
    Legend, I'll look those up when back at base this afternoon. Incidentally, one of the better guys at Capita's helpdesk was only able to find the SQL notes. Handy, still!

  18. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    It depends what you're doing, if you want teh installable release, you'll need to ask for it, but it's probably better to wait until near end of March when the new installable based on Spring 13 will be out.

  19. #14
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,068
    Thank Post
    811
    Thanked 352 Times in 276 Posts
    Blog Entries
    60
    Rep Power
    279
    I think the LDF file also grows if people don't log out and leave SIMS running overnight. Something about logged in users stopping proper maintenance.

  20. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,375
    Thank Post
    368
    Thanked 635 Times in 517 Posts
    Rep Power
    157
    That be a myth, can truncate the log file with users in, only way to stop it truncating would be if was writing - even then would only not be able to truncate that write. I think we found a few options what might be happening - SIMS Reindex Patch

  21. Thanks to matt40k from:

    CAM (27th February 2013)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 12
    Last Post: 25th April 2012, 10:14 PM
  2. Replies: 10
    Last Post: 6th December 2011, 01:22 PM
  3. [SIMS] Performance Issues in SIMS
    By newcareer in forum MIS Systems
    Replies: 1
    Last Post: 5th January 2011, 11:55 AM
  4. SIMS Performance
    By MattGibson in forum MIS Systems
    Replies: 22
    Last Post: 7th November 2008, 11:00 PM
  5. Sims Assessment Manager Performance Issues
    By barryfl in forum MIS Systems
    Replies: 4
    Last Post: 14th March 2006, 11:52 AM

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
  •