Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Attain & RAID
Poltergeist
Member Posts: 200
I've just been to the TINST course (Attain Installation) at Navision in the Netherlands, and had quite a discussion on the setup of the RAID system. Navision advices to set up a RAID 1, with database parts preferably not larger then 2 GB, all on different physical disks. That hasn't changed for years now. RAID 0+1 and RAID 5 are totally out of the question (according to Navision, that is). However, they could not provide me with any (new) benchmarks on the performance of the various RAIDsets.
I do understand that the above method has the highest performance rates (as Attain has it's own database managment system). However, It's very hard to persuade my clients that they have to by 32 disks (RAID1), and only 32GB will be used. They prefer a RAID1 set of 2 disks (1 and the mirror), or a RAID5 set. With Attain it is possible to create very large files (Navision has just upped the level to 128 GB), and I was wondering if and when using one large database file, which RAID set (not 0, as it has no redundancy) would give the best performance? RAID1 or RAID5?
Personally I think it should be possible to disable the DBMS which splits the data in various parts, and just let the RAID controller handle it... (no chance of seeing that happening soon, I'm afraid...
)
I do understand that the above method has the highest performance rates (as Attain has it's own database managment system). However, It's very hard to persuade my clients that they have to by 32 disks (RAID1), and only 32GB will be used. They prefer a RAID1 set of 2 disks (1 and the mirror), or a RAID5 set. With Attain it is possible to create very large files (Navision has just upped the level to 128 GB), and I was wondering if and when using one large database file, which RAID set (not 0, as it has no redundancy) would give the best performance? RAID1 or RAID5?
Personally I think it should be possible to disable the DBMS which splits the data in various parts, and just let the RAID controller handle it... (no chance of seeing that happening soon, I'm afraid...
) 0
Comments
//Lars Westman
http://www.linkedin.com/in/larswestman
Number of users ? 3, 30 or 300 ?
Type of company ?
The Navision recommended setup is the BEST setup you can get.
But your customer might do with less.
I guess making the database parts larger than 2 G will hurt less.
eg. 3 GB or 4 GB.
But you will need to start with 4 (8) disks or 5 (10).
If the total DB start size is 5 GB, then start with 5 parts of 1 GB
on 5 disks.
Best regards
Per