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 ...
8th October 2009, 09:57 PM #1
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.
8th October 2009, 10:00 PM #2
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.
8th October 2009, 11:23 PM #3
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.
8th October 2009, 11:27 PM #4
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
9th October 2009, 02:14 PM #5
Thanks for all the suggestions but after checking everything looks ok, guess it is time for a another server. Wonder who pay for it
By pooley in forum MIS Systems
Last Post: 13th March 2008, 10:40 AM
By enjay in forum MIS Systems
Last Post: 27th February 2008, 02:55 PM
By interele in forum MIS Systems
Last Post: 2nd February 2008, 06:43 PM
By andrewsmart in forum MIS Systems
Last Post: 14th June 2007, 09:13 PM
By Norphy in forum MIS Systems
Last Post: 5th April 2007, 11:20 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)