+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, New server in Technical; Hi all, We are moving MIS to Sims soon and I'm just wanting to get everyone's opinions on what my ...
  1. #1
    Marshall_IT's Avatar
    Join Date
    Jul 2011
    Location
    Leeds
    Posts
    459
    Thank Post
    72
    Thanked 57 Times in 48 Posts
    Blog Entries
    1
    Rep Power
    17

    New server

    Hi all,

    We are moving MIS to Sims soon and I'm just wanting to get everyone's opinions on what my server setup should be.

    On my old MIS u ran a separate joint Sql server to host the databases. Is this a good solution for sims or should I just dump everything on the dame server.

    Also what specs do you run, it'll be a VM on hyper V so I'm pretty flexible on what I can assign.

    Also any optimizations you can recommend would be great!

    Thanks.

  2. #2

    Join Date
    Jan 2014
    Location
    Isle Of Wight
    Posts
    81
    Thank Post
    85
    Thanked 7 Times in 7 Posts
    Rep Power
    3
    Our SIMS server is running Server 2008 R2 Sp1 (4GB Ram) as a MS Hyper-V virtual server.
    The host server is :

    • 2 x Intel Xeon Quad Core E5620 (2.40Ghz, 12mb, 5.86 QPI) Processor
    • 1 x Intel Server System (SR2600URBRPR) for Xeon 5500 CPU


    It hosts the SIMS Share (for clients), SQL Express Services, Solus 3 Services and Discover Services all under the 1 VM

    Because our database is under 2GB we haven't upgraded to the full SQL Server

    We have 30 workstations running sims from this server installation without a hiccup.
    Last edited by IWDave; 28th January 2014 at 09:39 PM.

  3. #3
    ass17's Avatar
    Join Date
    Feb 2013
    Posts
    317
    Thank Post
    5
    Thanked 35 Times in 34 Posts
    Rep Power
    25
    Quote Originally Posted by IWDave View Post
    Our SIMS server is running Server 2008 R2 Sp1 (4GB Ram) as a MS Hyper-V virtual server.
    The host server is :

    • 2 x Intel Xeon Quad Core E5620 (2.40Ghz, 12mb, 5.86 QPI) Processor
    • 1 x Intel Server System (SR2600URBRPR) for Xeon 5500 CPU


    It hosts the SIMS Share (for clients), SQL Express Services, Solus 3 Services and Discover Services all under the 1 VM

    Because our database is under 2GB we haven't upgraded to the full SQL Server

    We have 30 workstations running sims from this server installation without a hiccup.
    SQL express 2008 has a max db size of 10gb not 2gb.

    We run our server also as a VM on free VMware esxi.

  4. #4

    Join Date
    Jan 2014
    Location
    Isle Of Wight
    Posts
    81
    Thank Post
    85
    Thanked 7 Times in 7 Posts
    Rep Power
    3
    Cheers for the correction.

  5. #5
    ass17's Avatar
    Join Date
    Feb 2013
    Posts
    317
    Thank Post
    5
    Thanked 35 Times in 34 Posts
    Rep Power
    25
    No worries your welcome, I'm not sure many schools would ever go above 2gb for 1500 pupils details. We have been stuck on 1.2gb for five years!!

  6. #6

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,095
    Thank Post
    406
    Thanked 310 Times in 262 Posts
    Rep Power
    152
    isnt the issue with sql express the amount of RAM it can use?

  7. #7
    ass17's Avatar
    Join Date
    Feb 2013
    Posts
    317
    Thank Post
    5
    Thanked 35 Times in 34 Posts
    Rep Power
    25
    Correct still limited to 1 CPU and 1gb ram.

  8. #8

    Join Date
    Jan 2013
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Our SIMS.net and SQL database are on the same Hyper-V Virtual Machine running Server 2008 R2. The VM for SIMS.net has 16GB RAM and 4CPUs this is due to everything being on the same server. We run SQL 2008 R2 Full copy as this is such a large database used by 130 people or more all day, everyday. The only other thing I will say is make sure SIMS.net is the only SQL database installed on that SQL instance. This is stipulated in the terms and conditions of having the SIMS.net application.

  9. #9
    maark's Avatar
    Join Date
    Feb 2006
    Location
    leicester
    Posts
    470
    Thank Post
    90
    Thanked 73 Times in 65 Posts
    Rep Power
    38
    we have recently had a new sims server - virtual server hyper V 8GB ram allocated
    Server 2012 with MS SQL 2008 R2.
    Separate drives for sql data and docstorage.
    Quite a large school and all running ok so far.

SHARE:
+ Post New Thread

Similar Threads

  1. New server nightmare
    By dezt in forum Wireless Networks
    Replies: 10
    Last Post: 16th November 2006, 07:21 PM
  2. Replies: 1
    Last Post: 27th August 2006, 08:34 PM
  3. New Server Spec
    By plexer in forum Hardware
    Replies: 16
    Last Post: 26th May 2006, 09:28 AM
  4. new server from backup tapes
    By beeswax in forum Windows
    Replies: 8
    Last Post: 20th April 2006, 03:35 PM
  5. advice needed on weather a new server is needed
    By projector1 in forum Hardware
    Replies: 3
    Last Post: 24th February 2006, 09:20 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
  •