MIS Systems Thread, Sims running very slow in Technical; We have noticed since our data manager added all of the front page panels such as assesment data etc that ...
18th October 2009, 05:13 PM #1
- Rep Power
Sims running very slow
We have noticed since our data manager added all of the front page panels such as assesment data etc that the sims has become very slow.
We use SQL Express unfortunatly and the cpu usage now when there are about 70+ users on the system runs at 100% all day.
Taking the panels off seems to resolve the issue as does reducing the number of users on the system.
We are looking to upgrade the server to full SQL over the half term as it is a quad core with 4Gb so might as well get some software that can use the servers power.
In the mean time does anyone know how to globally reduce the refresh rate of these apps on the front page to at least reduce the CPU load.
Our Edit team isnt sure and we dont really want to have to log back into everyones users profiles and take off the panels only to have to put them back on in 2 weeks.
IDG Tech News
18th October 2009, 06:43 PM #2
Check Support net:- KB86810 - Homepage refresh times and rates
18th October 2009, 07:32 PM #3
I suspect the reason your CPU is at 100% is because SQL Express supports upto 1GB of memory, whereas normal SQL supports upto 4GB. I suspect the CPU is having to keep swapping information using up all your resources. There are big discounts to be had on SQL Server in Education, so I see little reason not to take advantage of that
18th October 2009, 09:58 PM #4
It's not much of a workaround, however:
i have lots of panels on my homepage and it's tremendously slow. Our server is supremely powerful, however it's my PC itself that runs slowly.
so, what i do is to turn my homepage off. it's 2 clicks away if you need it (in fact it can probably be made a shortcut and so only 1 click away), and has the added benefit that when you load it, it will update all panels and so be up-to-date. this actually speeds things up, so perhaps you could tell your users to turn it off. - i know, it's a pain expecting users to turn it on and off, but if you tell them it will speed their system up they might comply.
this way, you don't need to remove the panels and they can be set up ready to go, just not active. it's worth a try until you get a longer term fix.
19th October 2009, 09:58 AM #5
- Rep Power
Are you using lesion monitor as well, we found after applying update to 7.122 our server went to 50-100% CPU whenever anyone was logged on. Our LEA applied patch 13436 (not sure what it was nor can I see it on support net) but that sorted our problems
19th October 2009, 10:02 AM #6
Not sure how to change the refresh rate globally but you can change which panels people see globally so it would be straightforward to turn off panels for all users (and back on again) centrally so you wouldn't need to login to everyones profiles.
Originally Posted by wardsidjame
19th October 2009, 11:22 AM #7
CApita have also advised of a Routine that will Archive attendance marks for previous years. They will still be reportable but not editable. Reports are that this can speed up the system as and reporting / SQL access ignores these marks or something techy like that
Tools | housekeeping | Archive Attendance MArks
19th October 2009, 03:11 PM #8
I am sure I referred to exactly that above .............
Originally Posted by jcollings
Mind you - some of them are user defined and not globally defined.
Last edited by Sivadam; 19th October 2009 at 03:14 PM.
By gingesean in forum O/S Deployment
Last Post: 16th July 2009, 11:08 AM
By nicholab in forum Hardware
Last Post: 15th June 2009, 12:14 PM
By techyphil in forum MIS Systems
Last Post: 10th March 2009, 06:03 PM
By beeswax in forum EduGeek.net Site Problems
Last Post: 27th June 2008, 10:36 PM
By PEO in forum EduGeek Joomla 1.0 Package
Last Post: 13th May 2008, 03:23 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)