Jobos Posted June 26, 2015 Posted June 26, 2015 The LA is installing SQL 2014 on our Sims server the summer and we have a choice of either full or express. At the moment we are running the full version SQL 2008 but I expect SQL 2014 will put more pressure on the already tight memory. I did intend to replace it this year but there's no money to do it. The server handles AD, DNS, DHCP, file, Exchange and Sims/FMS. We did get a smaller server from the Olympics and have moved AV, WSUS and print over to that as VM's and it's my intention to move to 365 soon so Exchange will be gone too. The school is a primary, NOR 450 or so with 17 classes doing e registers. The office has 5 people using Sims and FMS. Discover is rarely used now since changing to Target Tracker. The Sims.mdf stands at 1.2GB. The SQL memory usage is my biggest concern as at the moment task monitor is showing 4.3GB of memory for sqlservr.exe. On the performance tab I've got 2.2GB of available memory and 0.6 free. So which version of SQL should I go for? The LA says there might be a drop performance moving to express but can't offer anymore help in deciding.
matt40k Posted June 26, 2015 Posted June 26, 2015 I'd use Express, easy enough to upgrade later if need, but to honest, primary schools should be OK. Also get rid of Exchange, move to Office 365.
Jobos Posted June 26, 2015 Author Posted June 26, 2015 I'd use Express, easy enough to upgrade later if need, but to honest, primary schools should be OK. Also get rid of Exchange, move to Office 365. Thanks that's what I thought would be the best option. The HT will be pleased when I tell him the licences would cost over £800 for the full version so a big saving there.
Edu-IT Posted June 28, 2015 Posted June 28, 2015 Thanks that's what I thought would be the best option. The HT will be pleased when I tell him the licences would cost over £800 for the full version so a big saving there. £800? I assume you don't have an EES agreement then?
Jobos Posted June 28, 2015 Author Posted June 28, 2015 £800? I assume you don't have an EES agreement then? That's right we buy the licences as and when. I did look into EES a few years ago but as the school has a high number of staff it wasn't worth it.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now