When it comes to database performance administrators don’t like surprises. Using the Pure Storage FlashArray™ with NVMe-oF transport protocol database administrators can achieve consistent performance levels for SQL Server workloads, and reduce the complexity of traditional DAS (direct attached storage) models.
The Pure Storage FlashArray with NVMe-oF delivers high performance in SQL Server environments providing steady write latency and bandwidth. Our tests using a real world SQL Server OLTP database workload with realistic data consisting of average 10K writes, and a read/write ratio of 20/80 resulted in tight standard deviation levels.
Write latency standard deviation resulted in 6 microseconds after 30 minute ramp time measured at the FlashArray storage layer 8 hour duration:
Write bandwidth standard deviation resulted in 6MB/s after 30 minute ramp time measured at the FlashArray storage layer 8 hour duration:
On the surface NVMe DAS (direct attached storage) sounds simple (i.e., just install some NVMe drives in a server) but looking deeper into the solution raises many questions.
DAS Drive Thermal Consideration
DAS Drive Performance Considerations:
DAS Drive Support Consideration:
DAS Drive Firmware Update Considerations:
Server Thermal Considerations:
NVMe DAS Resiliency Consideration:
With the Pure Storage Flash Array you are getting an end-to-end engineered solution built with our DFM (Direct Flash Modules) and Purity operating environment. Updates are simplified performance is consistent and efficient.
Trying to match DAS drive/card components with servers has so many performance environment unknowns. Now you no longer have to rely on a generic DAS drive/cards vendor IO controller, instead with FlashArray DFM (Direct Flash Modules) we are the IO controller.