MIS Systems Thread, SIMS and SQL 2008 DB and Log files on different drives in Technical; Originally Posted by jinnantonnix
Sounds like you're on the right track.
You might want to think about RAID 0+1 for ...
23rd June 2010, 01:15 PM #16
Originally Posted by jinnantonnix
The server box we have has 8 HDD. I currently have two in RAID 1 for OS (C drive) and then 3 in RAID 5 (DB drive) and 3 in RAID 5 (Log drive).
To get RAID 0+1 for our log drive I would either: need one more drive (not possible - server is at maximum capacity), or drop the OS down to no RAID, again not really somewhere I want to go!
So would you recommend that we setup the log drive in a RAID 1 and then have a hot spare in the server or setup the Database drive as RAID 1 and increase the log drive to RAID 0+1?
Or third option - leave it as it is???
IDG Tech News
23rd June 2010, 01:35 PM #17
Great. I will drop the log drive down to RAID 1 and set the spare disc up as a JBOD and use it for the SQL and OS Backup drive.
Thanks again for your time on this.
23rd June 2010, 01:57 PM #18
Yeah i get that having a dedicated disk or array would still give better performance but weighing up the 4 disk scenario, i think that 1 raid10 set would give overall better perfomance.
Originally Posted by jinnantonnix
27th July 2010, 09:55 PM #19
Is it possible to do the same thing with FMS, have the mdf and ldf on seperate drives?
27th July 2010, 10:17 PM #20
Yer, but why would you want to? FMS is tiny. The hassle it causes it just doesn't make sense.
Originally Posted by adamf
27th July 2010, 10:19 PM #21
Fair point.... I'll leave it where it is.
11th October 2010, 11:43 PM #22
Not an SQL expert but I have been running raid5 on our server for over 5 years and have not met with any speed or connectivity issues, granted there are probably only 50 or so users running lesson monitor and taking the register every lesson and have them taken within the first 5 mins.
Admittedly the very first login and connection to SQL is slower but not much and the time from entering credentials to user home page is 12 - 15 secs, have virtualised and tested the server and it is even faster at 5 secs.
It maybe the way in which our staff use the Sims but i would think that most schools use it the same as each other.
I am not sure that we would benefit from changing the way in which our SQL server is setup but I am thankful of the knowledge which you bring to this forum.
Thank you jinnantonnix
12th October 2010, 03:11 PM #23
I'd like to clarify a myth here: keeping your main database and log files on different physical disks is nothing to do with performance; it's for safety should a disk fail and you need to recreate one or the other.
edit: that is not that performance can't be increased by separating them, just that you probably won't notice one way or the other.
12th October 2010, 03:59 PM #24
This assumes your database isn't in simple recovery mode, which SIMS\FMS is....
By MYK-IT in forum MIS Systems
Last Post: 17th June 2010, 10:31 AM
By ful56_uk in forum Windows Server 2008
Last Post: 26th May 2010, 08:45 PM
By chazzy2501 in forum General Chat
Last Post: 30th April 2010, 12:31 PM
By Simcfc73 in forum MIS Systems
Last Post: 4th February 2010, 11:23 AM
By matt40k in forum MIS Systems
Last Post: 8th August 2009, 01:08 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread