+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, Existing SIMS server slowing down - spec? in Technical; Hi, I've had a few reports lately that our SIMS server is running slower than usual. It's running on ESX ...
  1. #1

    Join Date
    Apr 2008
    Location
    Keighley, West Yorks
    Posts
    274
    Thank Post
    38
    Thanked 43 Times in 37 Posts
    Rep Power
    20

    Existing SIMS server slowing down - spec?

    Hi,

    I've had a few reports lately that our SIMS server is running slower than usual. It's running on ESX virtual hosts so I gave it more memory to see if that helped, but it doesn't seem to have.

    Then yesterday I was at a Network Managers meeting and I heard people talking about their SIMS server having 8GB of memory - ours has 3GB...

    The SIMS virtual server has 2x 2.237GHz CPUs and 3GB memory. Database is 4GB, with 150+ users (of which probably 100 should be using it at a time for registers at the beginning of each lesson).

    It's currently Windows Server 2003 32-bit (not R2) so I know 4GB is the maximum there but if we need to install 2003 R2 or 2008 to up the memory then we can do - the hardware is 64-bit. Being virtual, we can increase the memory allocation easily - we have plenty spare capacity.

    How much memory should I be giving this server?

    Cheers,

    Peter

  2. #2
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    310
    Thank Post
    87
    Thanked 37 Times in 32 Posts
    Rep Power
    28
    You could try some of the suggestions on the supportnet site. The article covers lots of ways of increasing performance:

    KB89234

    Loads of useful stuff there.

    We are using a similar setup to you, but have got 4Gb of memory on the virtual machine. I will be running through the performance increasing measures listed over half term.
    Last edited by skunk; 23rd October 2009 at 10:29 AM.

  3. Thanks to skunk from:

    timzim (6th November 2009)

  4. #3

    Join Date
    Mar 2007
    Location
    The North of England
    Posts
    204
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    15

    Widgets

    Another addition to this list could be to get people to close down the widgets that appear on the home page of SIMS.net. We have found that these widgets are refreshing data constantly and if you imagine the number of connected workstations to your SIMS database during the course of the day and they are all refreshing then yes there is going to be some slow down. This has happened for us since the last upgrade of SIMS.net and I know it has affected quite a few schools. I'm hoping to use this as leverage to buy a new server though so it has it's benefits in the short term!!

  5. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,141
    Thank Post
    353
    Thanked 578 Times in 475 Posts
    Rep Power
    142
    Are you using the SQL Express? Cause if you are you've got 1x 2.2Ghz with 1gb ram.

    Be worth moving to x64.

  6. #5

    Join Date
    Mar 2007
    Location
    The North of England
    Posts
    204
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    15

    Server

    I think what he has there is fine and it should run on that spec quite easily.

    Mine has dual 3.0 GHz Xeons with 4Gb of RAM.

    I don't think it has anything to do with the servers at all. Like I said in my previous post prior to the August update things were running swimmingly now, the server seems to be drowning in these constant refreshes. I have asked staff to remove them from their home page and it has let up a little and crashing seems to have died down.

    Additionally you can open up the SQL Client Utility and move all the disabled protocols across to the right and tick the "enable Shared Memory" box and this seems to help a little also. I'm running my laptop on Windows 7 with the above configured and no widgets on the dash and it is working really well.

  7. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,141
    Thank Post
    353
    Thanked 578 Times in 475 Posts
    Rep Power
    142
    Number of people have said make sure you have 2x GB (both connected and teamed).

  8. #7


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,536
    Thank Post
    271
    Thanked 752 Times in 590 Posts
    Rep Power
    218
    I aim for database size + 1-2GB for everything else.

  9. #8
    ArchersIT's Avatar
    Join Date
    Nov 2006
    Location
    Bedfordshire
    Posts
    114
    Thank Post
    14
    Thanked 24 Times in 20 Posts
    Rep Power
    20
    If it has been slowing down recently I would strongly recommend looking at the widgets. The KB article that has sorted it for us is KB89941. This adds an index to the temporary tables which has restored performance back to what it should be

    HTH

    Jonathan

  10. #9

    Join Date
    Apr 2008
    Location
    Keighley, West Yorks
    Posts
    274
    Thank Post
    38
    Thanked 43 Times in 37 Posts
    Rep Power
    20
    Quote Originally Posted by skunk View Post
    You could try some of the suggestions on the supportnet site. The article covers lots of ways of increasing performance:

    KB89234

    Loads of useful stuff there.

    We are using a similar setup to you, but have got 4Gb of memory on the virtual machine. I will be running through the performance increasing measures listed over half term.
    Thanks for that - I'll have a look.

    Quote Originally Posted by ctbjs View Post
    Another addition to this list could be to get people to close down the widgets that appear on the home page of SIMS.net. We have found that these widgets are refreshing data constantly and if you imagine the number of connected workstations to your SIMS database during the course of the day and they are all refreshing then yes there is going to be some slow down. This has happened for us since the last upgrade of SIMS.net and I know it has affected quite a few schools. I'm hoping to use this as leverage to buy a new server though so it has it's benefits in the short term!!
    That's a shame, because we're starting to push out more of the widgets for centrally. Missing Registers is compulsary and some of the piecharts are used regularly.

    Quote Originally Posted by ctbjs View Post
    I think what he has there is fine and it should run on that spec quite easily.

    Mine has dual 3.0 GHz Xeons with 4Gb of RAM.
    Interesting - others seem to disagree?

    Quote Originally Posted by jinnantonnix View Post
    Don't forget to check your SQL server memory allocation.

    SQL Server Management Studio>Right-click your instance>Memory>set minimum to a sensible amount.
    It's set at 0 - is this bad?

    Quote Originally Posted by pete View Post
    I aim for database size + 1-2GB for everything else.
    That kind of ties in with what the guys were saying yesterday, which is why I was asking - but some of you are saying my 3GB should be ok.

    Quote Originally Posted by ArchersIT View Post
    If it has been slowing down recently I would strongly recommend looking at the widgets. The KB article that has sorted it for us is KB89941. This adds an index to the temporary tables which has restored performance back to what it should be
    Thanks Jonathan - I've now requested the Patch.

    I'll up the server to 4GB over half term as well.

    Peter

  11. #10

    Join Date
    Apr 2008
    Location
    Keighley, West Yorks
    Posts
    274
    Thank Post
    38
    Thanked 43 Times in 37 Posts
    Rep Power
    20
    Quote Originally Posted by jinnantonnix View Post
    Maybe.
    Hmm, thanks. I'll have a look around.

SHARE:
+ Post New Thread

Similar Threads

  1. Spec for SIMS server
    By KWestos in forum MIS Systems
    Replies: 20
    Last Post: 25th January 2010, 12:14 PM
  2. SIMS server spec
    By KWestos in forum Hardware
    Replies: 28
    Last Post: 9th July 2009, 11:56 PM
  3. Sims server spec
    By Jobos in forum Hardware
    Replies: 19
    Last Post: 20th May 2009, 11:14 PM
  4. Recommended Spec For Sims Server
    By dezt in forum MIS Systems
    Replies: 12
    Last Post: 17th January 2008, 08:19 AM
  5. image an existing server
    By CyberNerd in forum Thin Client and Virtual Machines
    Replies: 6
    Last Post: 19th February 2007, 10:28 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
  •