+ Post New Thread
Page 5 of 5 FirstFirst 12345
Results 61 to 65 of 65
MIS Systems Thread, Sims Server Performance Benchmarks in Technical; We're talking with Capita a lot currently due to performance issues that have gotten far worse since the Autumn upgrade. ...
  1. #61

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    6,227
    Thank Post
    603
    Thanked 1,092 Times in 840 Posts
    Blog Entries
    15
    Rep Power
    485
    We're talking with Capita a lot currently due to performance issues that have gotten far worse since the Autumn upgrade. When someone (data manager for example) is running a large report it generally makes it impossible for other users to log in, or if they can it's slow. Slows other users down to a crawl if not a halt.
    Reindexed, shrunk the log files but it's still a bit silly performance-wise. Considering the sheer grunt of our server (it's not even virtualised, we're effectively wasting it) and the capableness of the network I'm a little more than concerned about Capita's statement of the inevitability of it going "cloud based". I can only assume any plans to do so (are those plans still live? @PhilNeal , I seem to recall one of your guys blogging about it a couple of year ago?) would involve a lot of work internally more than just shifting it into a huge server farm as-is.

  2. #62

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,782
    Thank Post
    715
    Thanked 1,438 Times in 1,191 Posts
    Rep Power
    359
    @jinnantonnixx runs or did hundreds of setups on the same SQL server. It's possible. I'm sure they've had performance issues a big lately too. Not sure if it plagues them all or just individual DBs.

  3. #63

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    2,017
    Thank Post
    118
    Thanked 512 Times in 346 Posts
    Blog Entries
    2
    Rep Power
    288
    Quote Originally Posted by synaesthesia View Post
    We're talking with Capita a lot currently due to performance issues that have gotten far worse since the Autumn upgrade. When someone (data manager for example) is running a large report it generally makes it impossible for other users to log in, or if they can it's slow. Slows other users down to a crawl if not a halt.
    Reindexed, shrunk the log files but it's still a bit silly performance-wise. Considering the sheer grunt of our server (it's not even virtualised, we're effectively wasting it) and the capableness of the network I'm a little more than concerned about Capita's statement of the inevitability of it going "cloud based". I can only assume any plans to do so (are those plans still live? @PhilNeal , I seem to recall one of your guys blogging about it a couple of year ago?) would involve a lot of work internally more than just shifting it into a huge server farm as-is.

    We had dire performance, and the clients regularly timed-out. The report speeds are now back to normal after setting up a maintenance plan to rebuild indexes. The trouble with the SIMS reindex patch is that it doesn't update the statistics. Rebuilding the indexes generates new statistics so the query optimiser can produce better execution plans. If Capita added a further index for att_mark_normalised things would improve further.
    I've detailed this in another post about slow SIMS, link below.
    SIMS gradually getting slower and slower...
    Last edited by jinnantonnixx; 17th January 2014 at 09:09 AM.

  4. #64

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    @synaesthesia it'll be alot easier in a cloud environment, you not worrying about the 99 ways of the user has configured SQL, or if the hardware is the best it can be. Also you can actually run proper performance monitoring on the environment so you'll pick up some weird scenario that they've never seen before. This is assume you get a performance SLA of course!

  5. #65

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    6,227
    Thank Post
    603
    Thanked 1,092 Times in 840 Posts
    Blog Entries
    15
    Rep Power
    485
    That's true enough.
    I think it said a lot when we had a phone call from Capita to apologise for the delay in getting back to us on the open case, as they're overrun at the moment!

SHARE:
+ Post New Thread
Page 5 of 5 FirstFirst 12345

Similar Threads

  1. VMWARE : Can someone check this servers performance?
    By kennysarmy in forum Thin Client and Virtual Machines
    Replies: 8
    Last Post: 28th November 2012, 04:22 PM
  2. Server performance multiple VM vs 1 native OS
    By SimpleSi in forum Windows Server 2000/2003
    Replies: 3
    Last Post: 6th July 2012, 07:18 PM
  3. Server Performance
    By faza in forum Windows
    Replies: 17
    Last Post: 24th May 2006, 07:00 AM
  4. Server Performance
    By faza in forum Hardware
    Replies: 1
    Last Post: 23rd May 2006, 07:31 AM
  5. server benchmarks
    By browolf in forum Hardware
    Replies: 10
    Last Post: 14th October 2005, 10:03 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
  •