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
- 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
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
-
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)