MIS Systems Thread, SIMS.NET Running slow and causing network to freeze in Technical; Is anyone else having issues with the exams module?
Every time the exams officer uses exams, the server max's out. ...
6th March 2009, 10:45 AM #1
- Rep Power
SIMS.NET Running slow and causing network to freeze
Is anyone else having issues with the exams module?
Every time the exams officer uses exams, the server max's out. Now we thought it was a dodgy switch as the majority of machines suddenly crawl and this occurred once before as a result of a dodgy switch. After many days of trying to figure this out, it turned out to be SIMS.
.ICT have issued a patch to fix this but it hasn't worked. I wish they'd release a "KNOWN ISSUES" list by email. People working in excel seem to get hit hardest! Not sure why but it does.
Now is there a problem with Office 2003 as well? SIMS's is crawling these past few weeks.
7th March 2009, 07:03 PM #2
What do you mean? All the RAM is being used up, processor usage??
Originally Posted by techyphil
7th March 2009, 07:20 PM #3
The only part of Exams that I am aware of that can run sowly is seating and that is only on the workstation concerned.
7th March 2009, 08:56 PM #4
- Rep Power
It's a dual core XEON 2Ghz - 4GB RAM.
Yes Exams seating is a problem and there was supposed to be a patch to fix it. It hasnt worked. The CPU hits 50% when it runs a query allowing anything else to be processed on the other core. However, when she does exams, it maxes out both cores and anyone with a file open on a share located on the server is affected as well as sims users.
.ICT's advice is to a) Create the exams season again b) run the seating over night. We can't do B as there are looads and they all need to be done one at a time.
.ICT are looking into this.
8th March 2009, 10:08 PM #5
our sims isn't running slow, but i have noticed that the sql server in using 1.7gb of memory.
has anyone else got this high memory usage?
8th March 2009, 11:48 PM #6
I may be wrong but that 1.7GB may just be the size of the database. In which case having it all in memory should make things run quicker. How big is your sims .mdf file?
The maxing out of CPU and also increased memory is normal i think, it just shouldn't last long. I thought SQL was designed to use as much resource as was available to get the job done sooner.
If we do something on our server CPU spikes and then drops back down again.
9th March 2009, 09:54 AM #7
Quick question to the op, what spec is the machine you're running this on? And is it dedicated purely to SIMS?
9th March 2009, 11:09 AM #8
if your question was aimed at me then it,
Win 2k3, quad core 2.33 Mhz, 3.25 Gb of ram, our CPU usage never its more that about 49% on any core.
9th March 2009, 11:14 AM #9
It was aimed at the original poster
Originally Posted by penfold_99
1.7Gb isn't a lot for an sql server to be using memory wise. It just means your SIMS database is loaded into memory, so access times will be a lot quicker.
9th March 2009, 03:51 PM #10
- Rep Power
HP ProLiant ML350
It's a dual core XEON 2Ghz - 4GB RAM
.ICT are trying to resolve these issues for us.
We're planning on upgrading anyway to a HP ML370 G5 and would love to run Windows 2008 64bit and if possible SIMS on top of that. However, if its going to be an issue, i'd like place SIMS in a virtual machine so its easier for .ICT to take away the image and debug any further issues we have. Plus the benefits of being able to snapshot and duplicate the entire disk.
Last edited by techyphil; 9th March 2009 at 04:20 PM.
10th March 2009, 06:03 PM #11
Ahhh... that might explain why I have an SQL server instance running using a similarly rediculus amount of memory. CAPITA suggest a qucik reset of the SQL service to fix however if it's going to make SIMS run faster and I'm only using the server for SIMS and a little bit of file storage I might not bother for the moment.
Originally Posted by localzuk
By CM786 in forum MIS Systems
Last Post: 10th February 2014, 11:14 PM
By goodhead in forum Windows
Last Post: 12th June 2008, 06:52 PM
Last Post: 7th November 2007, 09:40 AM
By tobyhacker in forum MIS Systems
Last Post: 20th July 2007, 12:24 PM
By leonard.powers in forum MIS Systems
Last Post: 5th July 2007, 12:30 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)