+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 23
MIS Systems Thread, Slow SIMS.net in Technical; Hello all, We've been having a few issues here with our SQL Server which our SIMS sits on. Sims has ...
  1. #1

    Join Date
    Sep 2005
    Location
    Lowestoft
    Posts
    49
    Thank Post
    8
    Thanked 7 Times in 7 Posts
    Rep Power
    19

    Slow SIMS.net

    Hello all,

    We've been having a few issues here with our SQL Server which our SIMS sits on. Sims has recently been slowing right down so to log on can take up to 10 - 15 mins and in some instances time out.

    It seems that the sqlservr.exe process on the server is being hit pretty hard with the CPU usage at around 25% and the Mem Usage being over 1.13GB. The times when this is happening seems random it's not only when 60 odd teachers are logging on to do their lesson registers, it can be when only a handful of people are using SIMS.

    This only seems to have been happening since we did our March update via SOLUS.

    Has anyone else been experiencing these or similar problems? Also, does anyone have any ideas on how to resolve this? I'm still waiting to hear back from our LEA support team...

    Many thanks!

    Toby

  2. #2

    DaveP's Avatar
    Join Date
    Oct 2006
    Location
    Can't talk now: The mother-ship is calling!
    Posts
    8,699
    Thank Post
    351
    Thanked 1,268 Times in 866 Posts
    Blog Entries
    4
    Rep Power
    1124

    Re: Slow SIMS.net

    If the problem is only occurring at logon you could use this batch file to skip the checking for updates stage of the logon. I don’t recommend this, but it may help.

    Batch file:

    net use s: /d
    net use s: \\simsservername.domainname.local\simsroot$
    C:
    CD\Program Files\SIMS\SIMS .net\
    SIMSLoad.exe
    Pulsar.exe

    Batch file ends.

    This assumes:

    You are using S:\ as your SIMS drive
    Your copy of Windows is installed on C: and/or your SIMS on your hard disk is in C:\Program Files\SIMS
    Your stations where you will be running this have already been updated since the last SIMS upgrade using SOLUS.

    Note: ‘simsservername.domainname.local’ represents the fully qualified domain name of your SIMS server. Change the batch file to suit your school.

  3. #3

    Join Date
    Apr 2007
    Location
    NW1
    Posts
    38
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Slow SIMS.net

    I wouldn't have thought that would be the cause Dave as it wouldnt increase cpu/memory use.

    What size is the DB and Log toby? It might be worth backing up and trying to shrink the db.

  4. #4

    Join Date
    Sep 2005
    Location
    Lowestoft
    Posts
    49
    Thank Post
    8
    Thanked 7 Times in 7 Posts
    Rep Power
    19

    Re: Slow SIMS.net

    I do regular backups to shrink the DB so I can't see it being this (I clean up old backups regularly) After rebooting the SQL service the mem usage has been continually climbing upwards and is now up to 439MB at present.

    DB is just under 1GB with the log nothing to write home about.

    Still waiting to hear back from our LEA...

  5. #5


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,618
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223

    Re: Slow SIMS.net

    As a comparison my sql process is using 1.4 Gb of ram. This is normal and performs fine.

    Ideally, the SQL server should cache as much of the database as possible in ram.

  6. #6

    Join Date
    Sep 2005
    Location
    Lowestoft
    Posts
    49
    Thank Post
    8
    Thanked 7 Times in 7 Posts
    Rep Power
    19

    Re: Slow SIMS.net

    Hmm... thanks for the info Pete. When I spoke to our SIMS support team about this they did seem surprised about the size.

    Maybe something else is causing everything to slow up then?

    The hunt continues!

  7. #7

    DaveP's Avatar
    Join Date
    Oct 2006
    Location
    Can't talk now: The mother-ship is calling!
    Posts
    8,699
    Thank Post
    351
    Thanked 1,268 Times in 866 Posts
    Blog Entries
    4
    Rep Power
    1124

    Re: Slow SIMS.net

    Quote Originally Posted by tobyhacker
    ...The hunt continues!
    Would Process Explorer help you find it?

    Link: Process Explorer

  8. #8
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    62

    Re: Slow SIMS.net

    What Specification is your SIMS server?

    Andrew

  9. #9


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,618
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223

    Re: Slow SIMS.net

    Have you got a spare decent-spec workstation or space and enough grunt on your workstation to install vmware?

    Install SIMS on that, restore a pre-upgrade sims directory / database and then run the upgrade again.

    If nothing else it'll give you a similarly broken SIMS server that you can poke and prod without worrying about live data / users.

  10. #10
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,421
    Thank Post
    10
    Thanked 486 Times in 426 Posts
    Rep Power
    110

    Re: Slow SIMS.net

    Now up to 1.98 GB database. I'm glad I switched to the full sql 2000 from msde a few years back now.

  11. #11
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41

    Re: Slow SIMS.net

    Upgrading our sims server to ms sql 2005 from ms sql 2000 here. What is actually taking up cpu and memory? Do the clients actually hit the server when trying to log on or do they not get any further then their on compy... network problems?

  12. #12

    Join Date
    Apr 2007
    Location
    NW1
    Posts
    38
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Slow SIMS.net

    good point. Whats the login time like if you use the client on the sims server? If you can test that when other users are experiencing slow logins then perhaps you can rule out whether it's a network issue.

  13. #13

    Join Date
    Sep 2005
    Location
    Lowestoft
    Posts
    49
    Thank Post
    8
    Thanked 7 Times in 7 Posts
    Rep Power
    19

    Re: Slow SIMS.net

    When trying to log onto SIMS on the server itself when others are having issues can also take up to 5 mins or so. So I don't believe it to be a network issue.

    Our SIMS helpdesk has informed me that Capita say it is an SQL issue and that it maybe resolved when we move to SQL 2005 in August. Up till then we've got to manage, they gave a few suggestions which I've got to try.

    Server Spec is Xeon's with 4GB RAM lots of HDD etc etc. So in theory should be more than a match for SIMS!

    Things seem to have settled down today with no reports of problems with SIMS hanging or being slow to log on, so we shall continue to monitor it and see what happens!

    Many thanks for all your ideas!

    Toby

  14. #14
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41

    Re: Slow SIMS.net

    The usual capita answer, the fix is in the next upgrade... well in this case its it will be working for sql 2005. Whats the bet it will fix some problems but other will crop up or even revive an old one....

  15. #15

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,303
    Thank Post
    34
    Thanked 347 Times in 234 Posts
    Rep Power
    77

    Re: Slow SIMS.net

    I suspect that the problem is the anti-virus software. There is a paper on this on our SupportNet site.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Sims "checking for updates" really slow
    By zag in forum MIS Systems
    Replies: 2
    Last Post: 30th November 2007, 04:24 PM
  2. Slow PC
    By MrsGrinch in forum Windows
    Replies: 8
    Last Post: 16th November 2007, 04:53 PM
  3. FMS really slow - Just me or something else?
    By leonard.powers in forum MIS Systems
    Replies: 7
    Last Post: 26th September 2007, 09:24 PM
  4. Slow Logons
    By andyrite in forum Windows
    Replies: 3
    Last Post: 24th April 2007, 09:48 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
  •