MIS Systems Thread, New Sims Server Spec? in Technical; Hello,
at the moment we have out sims server running as a VM (Vmware) we are not happy with the ...
31st January 2014, 09:41 AM #1
- Rep Power
New Sims Server Spec?
at the moment we have out sims server running as a VM (Vmware) we are not happy with the current speed so we have decided to put sims back onto a Physical server.
i was wondering what spec you would give a sims server these days?
we have over 120-130 users on sims at once.
Sims DB size on SQL is 6781.44mb
31st January 2014, 10:49 AM #2
Is that the size of the actual MDF? That's the key number.
HP DL380\Dell R720 seem pretty popular at the moment with SQL 2012 standard, otherwise you'll have alot of free resources
HDDs are key, hearing great things about SSD so long as you have a enterprise grade and you have good support when they go wrong - they'll die within days of a each others - I've heard stories of them dying within 30mins of each other, still that's when they get to 3/5 year point so worth having at least a spare onsite if you do go down that path.
31st January 2014, 11:05 AM #3
We have a Dell R510 running our SIMS currently, as it matches the specification published by our LEA, (however alot of the newer servers on paper dont match the required GHZ which is complete crap, and to match the speed we would have needed to look at some really really ££££ equipment)
16GB ram and a RAID 10 X5660 xeon array on 15K disks and its not had any complaints yet, it also runs discover as well its very likely very under utilized but we got a good deal at the time and as such i dont see u needing to replace it for many years
Thanks to SHimmer45 from:
31st January 2014, 11:21 AM #4
31st January 2014, 12:01 PM #5
- Rep Power
One way to improve performance is to split the dbs across different logical drives. I have our MDFs on raid 1 SSDs and the LDFs on the SAS array. Plenty of RAM also helps
We have an online backup service so we are able to do hot backups to the cloud as well as local daily backups.
31st January 2014, 12:09 PM #6
I've got bags of nice servers and have done a few sims servers for Edugeekers and local NMs.
Drop me a pm and I'll get you some options
31st January 2014, 12:38 PM #7
Might be worth getting Capita to look at tables and the physical sizes @mm3, not saying you don't have a lot of data, it's just I found when I was looking into why a school was so big and trying to come up with a sizing guide, I found a few legacy tables that aren't used any more and few that we keeping data longer then I had hoped - no offence to Capita, but I don't really care that some teacher changed their password in 2004, especially when it's add a 1gb of data. I doubt it'll really help, but it'll help that new server go that little bit quicker.
31st January 2014, 12:42 PM #8
doesnt the daily backup of sims compact/delete certain logs to keep the database a reasonable size
31st January 2014, 12:56 PM #9
Being in a VM vs a physical shouldn't matter. Key to performance is to ensure that firstly the VM or physical is setup correctly, has adequate RAM and a high speed disk subsystem.
As has been said you want to split the MDF and LDF's onto different physical drives or different LUNs. It should also be a fast RAID type, so typically RAID-10 although RAID-5 is OK. Also look at other SQL performance tuning recommendations. I'm unsure what SIMS does/doesn't support as it's been a while, but typically you want to look at things like ensuring auto-growth (if enabled) is set to grow the database at a decent size (not growing by 1mb, instead growing at 500mb+ or similar) and MDF/NDF/LDF files are split onto different disks.
31st January 2014, 01:13 PM #10
@SHimmer45 - the backup will truncate the SQL log file - so the physical .LDF, assuming a few things - like it's under 4gb if it's recovery mode is set to FULL. It won't do anything with actual tables. Like remove old audit logs or removing records that even legally aren't allowed to be held anymore.
Split log file - MDF on one drive and LDF on another has been supported for a while. Me and Bob got that one pushed through Capita - good old Simon 1.0 @ Capita did have his uses. Growth size is a very good point - dbattach won't set it "correctly" so its worth a tweak and won't anger Capita. This will stop disc fragmentation so you database won't be randomly dotted about the hdd.
31st January 2014, 02:41 PM #11
@matt40k missunderstood what i was reading lol.
if it was me id be looking to put the sims DB on a fast local server rather rather than having data split across the host machine and a SAN
also if you have antivirus on a sims server (or any SQL DB) this can kill performance unless you exclude parts of the SQL install from being scanned.
Last edited by SHimmer45; 31st January 2014 at 02:43 PM.
By AJWhite1970 in forum MIS Systems
Last Post: 5th June 2013, 10:42 AM
By MrWu in forum MIS Systems
Last Post: 29th January 2013, 11:35 AM
By boolyn in forum MIS Systems
Last Post: 9th November 2011, 11:32 AM
By fiza in forum MIS Systems
Last Post: 15th May 2011, 03:12 PM
By Gatt in forum MIS Systems
Last Post: 1st May 2010, 01:15 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)