Choosing SSD drives for SQL Server
Posted on 2016-11-04
Let's compare only the performance of these two samsung SSDs which cost almost the same:
Let's not compare the other things like warranty, MTBF and TBW.
Consumer: Samsung 850 Pro 512GB
MLC chips, Read: 100K IOPS, Write: 90K IOPS, sequential 550 MBps (read)/ 470 MBps (write)
Enterprise: Samsung SM863 480GB
MLC chips, Read: 97K IOPS, Write: 26K IOPS, sequential 530 MBps (read)/ 480 MBps (write)
The drives (4) will run as RAID 10.
If you were to build an SQL Server for sharepoint, which one would you prefer performance-wise and why?