+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, SIMS SQL perfomance in Technical; Are other people are having problems with the SIMS SQL using most of the server resources and slow performance since ...
  1. #1
    smadison's Avatar
    Join Date
    Sep 2007
    Location
    UK
    Posts
    100
    Thank Post
    2
    Thanked 30 Times in 25 Posts
    Rep Power
    20

    Lightbulb SIMS SQL perfomance

    Are other people are having problems with the SIMS SQL using most of the server resources and slow performance since the last update. Staff are complaining about speed issues and after looking at it the network traffic is fine, memory usage is fine but SQL is causing the processor to run at 80 to 97 percent. Before any asks we have exceeded the recommended server specs.

    Any help would be greatful.

  2. #2

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,342
    Thank Post
    405
    Thanked 652 Times in 595 Posts
    Rep Power
    188
    Sorry which version are you running? The latest from our LA is August, are you newer than that? If not then I haven't noticed any issues with this release.

  3. #3
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    August (V,7,112) is the most recent releases. No Speed issues for us on this.
    Autumn Release (V7.114) is due on 19th October. With it is the facility to move to SQL Server 2008 - when it will be supported by Capita.

  4. #4

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,077
    Thank Post
    160
    Thanked 938 Times in 732 Posts
    Blog Entries
    3
    Rep Power
    275
    I did notice that a few of our reports had slown down since the last update, mainly the bigger ones.. but i was told that in the latest update the reports had slowed down and capita were aware of this. i am guessing it will be resolved in the next update

    Still pretty quick mind, but slower then they were before.. if the computer says Program Not Responding make sure your staff dont just quit SIMS.. it will be doing something just have to be patient.. unless it gives you an error leave it be


    James.

  5. #5
    smadison's Avatar
    Join Date
    Sep 2007
    Location
    UK
    Posts
    100
    Thank Post
    2
    Thanked 30 Times in 25 Posts
    Rep Power
    20
    Thanks for all the suggestions but after checking everything looks ok, guess it is time for a another server. Wonder who pay for it



SHARE:
+ Post New Thread

Similar Threads

  1. Ghosting sims @ sql
    By pooley in forum MIS Systems
    Replies: 0
    Last Post: 13th March 2008, 10:40 AM
  2. Old SIMS SQL Services
    By enjay in forum MIS Systems
    Replies: 5
    Last Post: 27th February 2008, 02:55 PM
  3. SIMS and SQL Express
    By interele in forum MIS Systems
    Replies: 3
    Last Post: 2nd February 2008, 06:43 PM
  4. SIMS and SQL, which version
    By andrewsmart in forum MIS Systems
    Replies: 4
    Last Post: 14th June 2007, 09:13 PM
  5. SIMS + SQL 2005?
    By Norphy in forum MIS Systems
    Replies: 22
    Last Post: 5th April 2007, 11:20 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
  •