The sun has officially set on the old Fusion-io®/SanDisk® ioMemory® PCIe Flash SSDs and its previous SQL Server Data Warehouse Fast Track performance and capacity records. Here and here! But don’t worry! Western Digital and HPE are delivering the next generation solutions with groundbreaking performance.
A little bit of background: Fusion-io developed a groundbreaking fusion of NAND flash memory and storage intelligence devices mounted on PCIe carrier cards. Over a quarter million Fusion ioMemory devices were shipped to thousands of global customers. In 2014, SanDisk acquired Fusion-io and ioMemory continued to be marketed under the SanDisk brand name. In 2016 SanDisk was acquired by Western Digital who also acquired solid-state technology leaders such as HGST, Virident, and sTec. With innovation up and down the stack, several new flash products have launched since the completion of these strategic acquisitions ranging from SSDs all the way to storage platforms and fully-featured all-flash systems.
Today we are highlighting one of the newest additions to our SAS SSDs portfolio, the ultra high-performance Ultrastar® SS300 and its SQL Server Data Warehouse Fast Track record-breaking performance and rated capacity. In these SQL Server Data Warehouse Fast Track solutions, forty-eight Ultrastar SS300s provide the storage performance to achieve the results highlighted in this blog post.
Both solutions were tested on the same HPE ProLiant DL580 Gen10 server. The 165TB rated Data Warehouse Fast Track solution leveraged the Intel® Xeon® Gold 6148 Processor while the 195TB calculated Data Warehouse Fast Track solutions used the Intel Xeon Platinum 8180 processor.
Forty-eight Ultrastar SS300 SSDs connect to six Smart Array controllers which feed into three processors via Gen3 x8 PCIe slots. Each Smart Array controllers hosts eight Ultrastar SS300 SSDs. Under synthetic load, peak performance reached 41GB/s. Each controller’s peak performance reached 6.83GB/s.
Breaking Down the Metrics
Both configurations take full advantage of the astounding storage configuration. The 195TB solution demanded more I/O as the Intel Xeon Platinum 8180 processor has more power and cores. This additional performance pushes the storage performance more than the Intel Xeon Gold 6148 processor.
SQL Server Data Warehouse Fast Track Certification Comparison
Summary – Record Breaking Performance and Capacity at Your Fingertips
To date, these SQL Server Data Warehouse Fast Track solutions provide the most performance and user capacity for Intel Purley-based solutions. For the most demanding data warehouse workloads, these Microsoft-validated, pre-configured solutions can offer high bandwidth of 24.5GB/s while maintaining <500 microsecond latency for accelerating business insights and faster results. The rated User Data Capacities of 165TB and 195TB provide enough storage for the most massive SQL Server data warehouses or large database consolidation projects so you can harness the power of data to find new opportunities and transform your business.
Download the DWFT Reference Architecture White Papers
Brian is a Senior Technologist for the Fabric integration and Solutions Team.Brian has over a decade experience in database, server, and storage technologies, including DBA and Architect positions at Microsoft, Fusion-io and SanDisk.He was previously part of the Data Propulsion Labs’ Microsoft Advisory Team where he authored white papers demonstrating SanDisk and HGST solutions ability to deliver cutting–edge storage performance Microsoft technologies such as SQL Server and Hyper-V.