Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
NAV 2018 on NVMe disks
lzr
Member Posts: 264
in SQL General
It's time to upgrade and I am looking to purchase a new server for our company.
One of the options is to use NVMe disks instead of a standard server with SSD/15k spinners. The NVME alternative is cheaper and offers better speed.
The "disadvantage" with NVMe seems to be that it's not using standard raid so Windows/VMWare (will have VMWare at the bottom and a single Windows installation on top of that) will have to be setup with software raid 10.
Would love to hear your thoughts on this setup.
One of the options is to use NVMe disks instead of a standard server with SSD/15k spinners. The NVME alternative is cheaper and offers better speed.
The "disadvantage" with NVMe seems to be that it's not using standard raid so Windows/VMWare (will have VMWare at the bottom and a single Windows installation on top of that) will have to be setup with software raid 10.
Would love to hear your thoughts on this setup.
Navision developer
0
Best Answer
-
Options
Slawek_Guzek
Member Posts: 1,690
I'd thought that the NVMe is the most expensive solution, then the SSD, and then 'old good' 15k spinners
The overhead of software RAID will be miimal comparing to the NVMe performance advantages, so if you really find the NVMe based solution to be the cheapest one go for it.
Usually the NVMes are only used to store volumes where SQL Server transaction log files are kept, to speed up transaction committing. SQL Server can recognize properly configures NVMe based volume and the commit process does not require to copy entire 4k long block of transaction log records onto permanent storage device. It makes massive difference when the SQL Server experiences a big number of relatively short transactions. In non NVMe based environments the problem was alleviated by using delayed durability database setting.
Having said that I am not sure if you will be able to realize fully the NVMe disk based volume advantages in the SQL Server if you put the VMWare layer atop of the NVME disk.
Slawek Guzek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-036
Answers
The overhead of software RAID will be miimal comparing to the NVMe performance advantages, so if you really find the NVMe based solution to be the cheapest one go for it.
Usually the NVMes are only used to store volumes where SQL Server transaction log files are kept, to speed up transaction committing. SQL Server can recognize properly configures NVMe based volume and the commit process does not require to copy entire 4k long block of transaction log records onto permanent storage device. It makes massive difference when the SQL Server experiences a big number of relatively short transactions. In non NVMe based environments the problem was alleviated by using delayed durability database setting.
Having said that I am not sure if you will be able to realize fully the NVMe disk based volume advantages in the SQL Server if you put the VMWare layer atop of the NVME disk.
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
Thanks a lot for your input, I will check pricing on a cheaper option as well and then decide (using 6G SSD SATA disks)