MIS Systems Thread, SIMS Server and SIMS Databse - On the same server? Or on seperate servers? in Technical; As it stands we have our Database and Document Server on a separate box to our SIMS Server.
At the ...
6th May 2013, 11:22 AM #1
SIMS Server and SIMS Databse - On the same server? Or on seperate servers?
As it stands we have our Database and Document Server on a separate box to our SIMS Server.
At the moment both the box that holds our SQL Server and the box that holds our SIMS Server are nearing End Of Life so I was wondering moving forward if it's best to keep them separate or to move them to the same new server?
I've heard contradicting advise on what best practice is regarding SIMS so what do you do?
6th May 2013, 11:27 AM #2
I'm a little confused - what do you have hosted on your 'SIMS Server' if not the database or document server? All SIMS consists of is the database, document server and the file share containing the setup files and related bits and bobs? Do you mean you have the file share on a different server?
There's absolutely no need to separate off the file share to be honest - the data usage via it are minimal.
We have the lot in a single VM.
6th May 2013, 11:35 AM #3
What sort of resources have you got on your VM? We are in pretty much the same boat as @Sam_Brown - thanks
6th May 2013, 11:37 AM #4
Originally Posted by localzuk
For as long as I can remember it's been set up like this where I work but I never really understood why. Now the old boss is gone and we need to move to a new box sometime soon I saw no reason why we couldn't stick it on one piece of kit. However not really being involved in SIMS before I wanted to ask what other people did first in case there was a reason for it I missed.
6th May 2013, 11:40 AM #5
Our host nodes are HP DL380p Gen8's with dual E5-2690 processors and 96GB of RAM. They use a central storage server with 16x 100GB SSDs, interconnected with 10GbE. (For background, to give a sense of what components are actually being used).
The SIMS VM itself has 8 cores and 8GB RAM. The highest CPU usage we've seen was 12% - and that was 'start of lesson 1 everyone logging in' time - after the recent Spring update. Our setup is way overkill though, no doubt about that. The server also hosts SOLUS 3 and Discover, along with our cashless catering system.
Oh, and for a sense of scale - we have about 45 users in SIMS at any one time, as all teachers use it, as do admin, behaviour and SEN etc...
Last edited by localzuk; 6th May 2013 at 11:41 AM.
Thanks to localzuk from:
sister_annex (6th May 2013)
6th May 2013, 12:41 PM #6
Perhaps at the time for load balancing it was deemed appropriate to separate the two services, or there were plans to add more SQL DBs into the database server.
Some places have a dedicated SQL server and SIMS would be an instance on that. In that scenario you might choose to hold the documents / files separately.
We have it all in one here too, as per spec in sig. It runs pretty well.
6th May 2013, 12:50 PM #7
We have ours on a single VM. It has 4 cores and 8GB of RAM and has run fine until the last patch. CPU usage has never really been an issue (until now obviously) but SQL Server will gobble up all the RAM it can!
10th May 2013, 09:58 PM #8
we have ours like this as we ended up with 10+ different VMs run SQL and decided to consolidate.
Originally Posted by vikpaw
Although having SIMS + SQL self contained on one VM has a huge advantage, "Take Snapshot" !
11th May 2013, 11:38 AM #9
I got a ticket on the helpdesk at the end of last week from the NM, asking for the SIMS snapshots to be deleted, as the ~200GB server was taking up over 1TB with all the snapshots going back 2 years.
For most SQL apps, consolidating would work well. I like that i have SIMS as a separate VM so i can reboot easily and not affect the others, plus like you say, snapshot is an advantage. I have now deleted a few old ones, but that means, that the backups i have been keeping from the days of yore, wont be usable as i'm pretty sure if i restore the old backup to a new install it won't recognise it or complain about incompatibilities and table changes. I wouldn't want to work out which files were new in setups and swap them out or restore from backup and then rollback the client app which is probably the only workaround.
Now we're going to have to rely on taking a backup of the VM file itself that happens with the overall site backup, and slows down the recovery time.
I know i shouldn't rely on snapshot for backups, but it's so quick and easy to do
11th May 2013, 11:42 AM #10
we keep vm snapshots for 24 hours max. after that its preyy much useless
11th May 2013, 12:14 PM #11
I know, we'd never use it for live rollback, too much data to lose, even in a few hours. It's more so you can at least look at how things were at a point in the past, which we do a lot. It's also useful to restore to a test server and extract info / reports / templates that may have been deleted, for later reimport to live server.
It's a pain but with no auditing, keeping lots of old backups is the only way we have to easily trace things, on those rare occasions we need to.
11th May 2013, 12:37 PM #12
in that kind of situation i would just restore the vms from a backup.
out of interest what hypervisor are you using? it says vmware in your signature. surely that's horrifically slow have that many snapshots on a vm?
11th May 2013, 12:49 PM #13
VMWare - no slowdown. It works like lightning. Not much data is changed in practise and it's only ever a diff to the last file. Removing one took 45 minutes though and subsequent ones have been 20 mins.
11th May 2013, 12:55 PM #14
yes you have a point actually, on ours it would be max 2gb of sql data.
Originally Posted by vikpaw
By DJ-Jonesy in forum Enterprise Software
Last Post: 14th February 2013, 11:02 AM
Last Post: 30th October 2008, 03:52 PM
By laserblazer in forum Hardware
Last Post: 24th February 2008, 11:41 AM
By tosca925 in forum Windows
Last Post: 7th May 2007, 09:58 PM
By drjturner in forum Mac
Last Post: 30th June 2006, 09:53 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)