Accelerating SQL Server with IntelliFlash Arrays

Issue link:

Contents of this Issue


Page 0 of 2

Highlights • Crush database latency at a lower cost than traditional storage • Instantly provision volumes tuned for SQL Server with application-aware provisioning • Thin provision volumes and compress databases in line to significantly reduce your storage footprint • Create application-consistent snapshots to prevent data loss and ensure recovery • Quickly recover from a site disaster with remote replication Accelerating SQL Server ® with IntelliFlash ™ Arrays Accelerate Database Throughput and Response Times While Reducing Your Storage Footprint Your business depends on Microsoft SQL Server ® databases for data warehousing, analytics, and online transaction (OLTP) workloads. It's essential that you deliver consistently high levels of performance and availability. But that can be difficult without the right storage infrastructure. As a result, revenue and productivity can suffer. Western Digital IntelliFlash arrays offer a comprehensive portfolio of all-flash and hybrid flash storage solutions that deliver high I/O per second (IOPS) at sustained low latency at a price that will fit most budgets. Each array includes a comprehensive set of data protection and management capabilities and can seamlessly support different storage media (NVMe TM flash, performance flash, dense flash, and hard drives) powered by the IntelliFlash Operating Environment. Dial up or down the amount of flash storage to meet your performance needs. Get the lightning-fast performance of flash with the cost-effective economics of disk. Dramatically Improve Database Response Times IntelliFlash arrays are able to reduce SQL Server database transaction wait times to sub-millisecond. The lntelliFlash Operating Environment is flash-optimized to seamlessly integrate multiple types of storage media (NVMe, performance flash, dense flash, and HDDs) to deliver optimal performance and capacity. IntelliFlash arrays achieve this by automatically separating metadata from data. The metadata is then organized, aggregated, and retained in a dedicated section within the performance tier (DRAM, NVDIMM, NVMe and performance flash) for the fastest possible response times. This stands in stark contrast with traditional storage solutions that intermingle data with metadata into one storage pool. IntelliFlash also employs intelligent caching algorithms to place the most frequently accessed application data on NVDIMM, DRAM, NVMe and performance flash. These algorithms are optimized for various l/0 patterns and seamlessly adapt to disparate latencies across multiple levels of cache. Additionally, you can supercharge performance of your SQL Server databases by pinning tempdb and log files to an all-flash storage pool. Accelerating SQL Server on IntelliFlash Arrays • All-flash arrays for sustained low latency • 48 TB‡ of all-flash in 2 rack units • 336TB in 10 rack units • Sub-millisecond latency • All-flash and hybrid flash arrays for most SQL server workloads • Pin redo logs and temp tables in all-flash storage pool • Run rest of the DB in hybrid storage pool • Cost-effective performance and capacity ‡ One GB is equal to one billion bytes and one TB equals 1,000GB (one trillion bytes) when referring to storage capacity. Accessible capacity will vary from the stated capacity due to formatting and partitioning of the drives, the operating system and other factors. SOLUTION BRIEF

Articles in this issue

view archives of IntelliFlash - Accelerating SQL Server with IntelliFlash Arrays