NVMe Drives vs SAS SSD

ara3n
Member Posts: 9,258
Hello
Has anybody looked at the server hardware recently for NAV db on sql server?
NVMe drives don't support RAID so I'm trying to figure out if it worth getting them. And if we do, what should be put on it? Just the Tempdb?
The current server db size is 800 gigs with 200 concurrent users.
Any experience is appreciated.
Thanks.
Has anybody looked at the server hardware recently for NAV db on sql server?
NVMe drives don't support RAID so I'm trying to figure out if it worth getting them. And if we do, what should be put on it? Just the Tempdb?
The current server db size is 800 gigs with 200 concurrent users.
Any experience is appreciated.
Thanks.
0
Comments
-
Not worth it. If you put those to be used only to put the temp DB's and it fails, your server comes crashing down until you replace the drive. You don't want that.
You might use them for test machines BUT ONLY if you don't care whatever you lose on it in case of drive failure.
Personally I wouldn't use them.
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
If you run SQL Server 2016 on Windows Server 2016, there is an optimization to put the tail of (transaction) log on NVMe, see
https://blogs.msdn.microsoft.com/bobsql/2016/11/08/how-it-works-it-just-runs-faster-non-volatile-memory-sql-server-tail-of-log-caching-on-nvdimm/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