RAID Question

damir
damir Member Posts: 28
edited 2006-11-28 in Navision Attain
I am wondering whether I would get better performance from RAID 10 with 6 disks and with one database file, or having 3 database files RAID 1 with 2 disks each. This is using Navision Database Server.
Has anybody tried this combinations?

TIA,
Damir

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    I never tried it. But I heard a rumour that 3 times RAID1 is better than 1 RAID10 with 6 disks. So I can't guarantee it is better.
    The advantage with RAID10 is that you have 1 BIG logical drive and 1 BIG DB-file. This is advantageous for administrating, because you only have 1 DB-file.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • bbrown
    bbrown Member Posts: 3,268
    In the situation you describe, assuming the same hardware, I would say that the 3 RAID 1 sets would provide better performance. Navision uses a separate process to manage the I/O for each database file. In your RAID 10 example a single process would be tasked with 100% of the I/) demand. In the RAID 1 example, the load would be shared among the 3 processes. SQL has similar functionality by splitting filegroups across multiple physical files.

    The bottleneck for any one of the processes becomes how fast the disk system can service the request. One interesting approach is to combine the two solutions on large databases. That is create multiple database files, and place each on its own RAID 10 array. The configuration possibilities are limited only by imagination and budget.
    There are no bugs - only undocumented features.
  • Waldo
    Waldo Member Posts: 3,412
    I can confirm this.

    In my former company, they (not me) did some kind of benchmark and 3 times RAID 1 seemed slightly better. (they did it with 4 sets and a database of 40GB).

    bbrowns explanation confirms it again ...

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Waldo
    Waldo Member Posts: 3,412
    Actually, I posted this question 3 years ago... :)
    RAID 0+1 or RAID 1?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • kine
    kine Member Posts: 12,562
    If you are talking about Native DB, more files on more physical volumes is better. Of course, do not forget that you need not overload the RAID processor... (control unit has limited command queue)...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • damir
    damir Member Posts: 28
    Thank you all very much.
    I thought that one RAID10 would be better solution, since all job with splitting and merging parts of data is done by controller.
    However, it looks like Navision Server is doing admirable job.
  • Waldo
    Waldo Member Posts: 3,412
    Never underestimate the power of the native ... 8)

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog

Categories