+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
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 ...
  1. #16
    jonwitts's Avatar
    Join Date
    Dec 2006
    Location
    England
    Posts
    132
    Thank Post
    17
    Thanked 12 Times in 11 Posts
    Blog Entries
    1
    Rep Power
    18
    Quote Originally Posted by jinnantonnix View Post
    Sounds like you're on the right track.

    You might want to think about RAID 0+1 for logs.
    @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???

    Jon

  2. #17
    jonwitts's Avatar
    Join Date
    Dec 2006
    Location
    England
    Posts
    132
    Thank Post
    17
    Thanked 12 Times in 11 Posts
    Blog Entries
    1
    Rep Power
    18
    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.

    Jon

  3. #18
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Quote Originally Posted by jinnantonnix View Post
    Even if you keep it on Simple (which means back to last night's backup), you'll still get better performance with a dedicated disk or array for the log, even though the log restore feature has gone out of the window.
    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.

  4. #19

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    500
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    21
    Is it possible to do the same thing with FMS, have the mdf and ldf on seperate drives?

  5. #20

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,392
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Quote Originally Posted by adamf View Post
    Is it possible to do the same thing with FMS, have the mdf and ldf on seperate drives?
    Yer, but why would you want to? FMS is tiny. The hassle it causes it just doesn't make sense.

  6. #21

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    500
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    21
    Fair point.... I'll leave it where it is.

  7. #22

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,905
    Thank Post
    1,186
    Thanked 1,057 Times in 749 Posts
    Rep Power
    328
    @jinnantonnix:

    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

  8. #23

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,859
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    182
    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.

  9. #24

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,392
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    This assumes your database isn't in simple recovery mode, which SIMS\FMS is....

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. New SIMS Server - Windows 2008 R2 & SQL 2008 R2
    By MYK-IT in forum MIS Systems
    Replies: 23
    Last Post: 17th June 2010, 09:31 AM
  2. sql 2008 shrink log file
    By ful56_uk in forum Windows Server 2008
    Replies: 2
    Last Post: 26th May 2010, 07:45 PM
  3. Who's doing their SQL 2008 Migration for SIMS today?
    By chazzy2501 in forum General Chat
    Replies: 4
    Last Post: 30th April 2010, 11:31 AM
  4. Sims SQL 2008 install
    By Simcfc73 in forum MIS Systems
    Replies: 11
    Last Post: 4th February 2010, 10:23 AM
  5. SIMS SQL 2008 migration
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 8th August 2009, 12:08 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •