THE RAID 5 thread
Comments
-
Hello DenSter,
This discussion is in 2012,is there any news for RAID5 performance for new NAV and SQL Versions???
Thanks in advance...0 -
Everything remains as before. RAID 5 is fast for reads but slow for writes. SAN write cache can help for the writes. Separating the LOG file on a RAID 1 or RAID 10 and keeping the DB on RAID 5 helps. Having SSD is better than classic discs.
One change for SQL though: SQL2014 has delayed durability for databases.
In short : it means SQL takes writes in memory, confirms the COMMIT and then it writes it to the disk.
It works like the COMMIT cache on native DB. So if you lose power between the COMMIT and the writing to disk, you lose these COMMITS. You should maximum lose the last few minutes. So you would not lose much data.
And the chance the servers goes down is very low. If these kind of losses are acceptable to get better performance, you can implement it. But I would first try without without using this.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!1 -
I've been out of performance troubleshooting for years, so what I know is outdated quite a bit. I don't think RAID 5 has changed though, so all concerns still apply.
I do think that disk performance has improved a lot over the years, and NAV on SQL Server is a LOT better than it used to be, so I don't know if RAID 5 is still as much of a problem as it used to be.
Find someone who is current on this in your specific configuration and have them analyze your system.0 -
Basically, they have the same problems as before, but SAN-technology, disk-technology, NAV-on-SQL technology (the commands that NAV sends to SQL) are all improved, so you don't feel the impact so much. Remember also that NAV is not set-based and there is a lot of business logic processing while doing TSQL commands. So it almost never gets to performance limits of the disks.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions