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 ...
28th January 2014, 09:22 PM #1
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!
28th January 2014, 09:37 PM #2
- Rep Power
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.
28th January 2014, 10:08 PM #3
SQL express 2008 has a max db size of 10gb not 2gb.
Originally Posted by IWDave
We run our server also as a VM on free VMware esxi.
28th January 2014, 10:15 PM #4
- Rep Power
Cheers for the correction.
28th January 2014, 10:18 PM #5
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!!
28th January 2014, 10:21 PM #6
isnt the issue with sql express the amount of RAM it can use?
28th January 2014, 10:28 PM #7
Correct still limited to 1 CPU and 1gb ram.
29th January 2014, 08:17 AM #8
- Rep Power
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.
29th January 2014, 09:20 AM #9
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.
By dezt in forum Wireless Networks
Last Post: 16th November 2006, 07:21 PM
By ajbritton in forum Windows
Last Post: 27th August 2006, 08:34 PM
By plexer in forum Hardware
Last Post: 26th May 2006, 09:28 AM
By beeswax in forum Windows
Last Post: 20th April 2006, 03:35 PM
By projector1 in forum Hardware
Last Post: 24th February 2006, 09:20 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)