100 TB data Warehouse Fast Track

Reference Architecture for Microsoft SQLServer 2017

read whitepaper

Reference Architecture

This Broadcom®, Kaminario, and Microsoft® SQL Server Data Warehouse Fast Track (DWFT) Reference Architecture provides guidelines and principles to assist customers in designing and implementing a balanced configuration for Microsoft SQL Server® data warehouse workloads to achieve out-of-the-box high performance. These database reference architectures enable each of the components in the database stack to provide optimal throughput to match the database capabilities of the specific setup. This paper describes the designs, configuration and guidelines used to achieve an optimally balanced 100TB DWFT reference architecture for SQL Server 2017 using Emulex Gen 6 HBAs by Broadcom, a Kaminario K2 all-flash array and HPE DL380 Gen10 servers providing at least 12,800MB/s of throughput.

VMware VDI on Kaminario K2

Cobb Electric Membership Corporation adopts Kaminario’s next generation all flash storage platform to realize the performance, scalability, and simplicity of the all flash data center.  

Consolidated Container, a leading developer and manufacturer of rigid plastic packaging solutions, gains IS operational simplicity and future-proof performance with Kaminario K2.

Howard Marks


Kaminario’s K2.N demonstrates how fast the storage industry moves, just a year after the standardization of NVMe over fabrics K2.N leverages NVMEoF’s to create an ultra-low latency scaleable storage fabric. Since K2.N extends Kaminario’s VisionOS to support NVMEoF customers don’t have to choose between networked NVMe’s performance and data services as they would with many of the startup’s more limited or proprietary systems. With the addition of Kaminario Flex, K2.N will become a completely composable system allowing users to orchestrate controllers and NVMe JBOF storage dynamically into virtual arrays for almost unlimited flexibility and efficiency.