NVMe Drives vs SAS SSD

ara3n

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.

kriki

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.

kennie

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/