+ Post New Thread
Results 1 to 11 of 11
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. ...
  1. #1

    Join Date
    Mar 2007
    Posts
    323
    Thank Post
    6
    Thanked 7 Times in 6 Posts
    Rep Power
    17

    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.

    Thanks

  2. #2

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    501
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    22
    Quote Originally Posted by techyphil View Post
    the server max's out
    What do you mean? All the RAM is being used up, processor usage??

  3. #3

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,331
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    The only part of Exams that I am aware of that can run sowly is seating and that is only on the workstation concerned.

  4. #4

    Join Date
    Mar 2007
    Posts
    323
    Thank Post
    6
    Thanked 7 Times in 6 Posts
    Rep Power
    17
    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.

    Cheers

  5. #5
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    936
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    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?

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,008
    Thank Post
    680
    Thanked 1,396 Times in 1,156 Posts
    Rep Power
    353
    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.

  7. #7

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,807
    Thank Post
    517
    Thanked 2,469 Times in 1,913 Posts
    Blog Entries
    24
    Rep Power
    835
    Quick question to the op, what spec is the machine you're running this on? And is it dedicated purely to SIMS?

  8. #8
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    936
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    @localzuk

    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.

  9. #9

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,807
    Thank Post
    517
    Thanked 2,469 Times in 1,913 Posts
    Blog Entries
    24
    Rep Power
    835
    Quote Originally Posted by penfold_99 View Post
    @localzuk

    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.
    It was aimed at the original poster

    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.

  10. #10

    Join Date
    Mar 2007
    Posts
    323
    Thank Post
    6
    Thanked 7 Times in 6 Posts
    Rep Power
    17
    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 03:20 PM.

  11. #11

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,678
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45
    Quote Originally Posted by localzuk View Post
    It was aimed at the original poster

    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.
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 35
    Last Post: 10th February 2014, 10:14 PM
  2. what is causing our pcs to go slow.
    By goodhead in forum Windows
    Replies: 5
    Last Post: 12th June 2008, 05:52 PM
  3. VB.Net running on your network?
    By Andi in forum Windows
    Replies: 9
    Last Post: 7th November 2007, 08:40 AM
  4. Slow SIMS.net
    By tobyhacker in forum MIS Systems
    Replies: 22
    Last Post: 20th July 2007, 11:24 AM
  5. sims.net running on Virtual Server 2005r2 ???
    By leonard.powers in forum MIS Systems
    Replies: 2
    Last Post: 4th July 2007, 11:30 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
  •