Running SQL Server on Pure Storage's All-Flash Architecture
Latency is the life-blood of any database application. When transactions slow, it is often a direct result of disk contention at the storage layer driving-up storage I/O latency, which directly translates into slower transactions and a slower end-user experience. Moving to an all-flash architecture for your database affords immediate and obvious performance benefits, but also introduces a whole host of operational benefits. Simply put, running your databases on flash can be dramatically faster, and dramatically easier to manage.
Our analytics application was bringing our high-end disk storage array to its knees. Moving to Pure Storage gave us tons of performance headroom, and our Microsoft SQL data was reduced 9-to-1; we were shocked!
- Jeff Geltz, CIO, Mattersight
Running Microsoft SQL on Pure Storage allows you to:
- Accelerate Redo Logs. The first disk choke-point for SQL is the redo logs. Migrating redo logs to flash enables faster flush times and faster recoveries.
- Reduce Indexes. In high-performance OLTP environments indexes are a key tool to improving transactional performance, but creating and managing indexes is costly and each requires its own overhead. Migrating your db file to the FlashArray will deliver a universal boost in performance that will accelerate b-tree navigation in indexes, bookmark lookup operations and even table scans far beyond what any magnetic disk could ever provide, at a fraction of the cost of other solid state based architectures.
- Simplify Data Layout. As a DBA, you've probably been forced to get a PhD in storage, understanding in great detail how LUNs are striped across spindles in your storage architecture. Getting the best performance out of SQL Server in the past has required complex architecture of your underlying storage objects, creating just the right performance profile for logs, indexes, data files, and temp databases. With Pure Storage, you don’t need to worry about running out of drive letters or an unmanageable number of mount points. Create one LUN per file type, put everything in it. Done. Fast.
- Any SQL Block Size. In addition to understanding your storage LUN layout, fine-tuning the SQL Server block size has also been critical to ensuring performance, so that SQL Server blocks aligned harmoniously with the storage geometry. Pure Storage's 512-byte virtualization architecture means block alignment issues disappear. Pick any block size, they're all fast.
- Virtualize SQL Without Fear. Yes, you can with Pure Storage. Tier 1 databases typically drive highly random I/O, and are incredibly latency-sensitive...not the kind of application that suits itself to virtualization, until now. The abundant low-latency random IOPS that Pure Storage delivers enables the virtualization of SQL with ease.
- Reduce Data with no Performance Penalty. Pure Storage's inline deduplication and compression function seamlessly in SQL Server environments, allowing reduction of Microsoft SQL database instances by 3-10x with no performance hit.
- Consolidation and SQL License Reduction. Lower latency and higher transactional throughput means that for most people, SQL instances can be reduced by up to 50%. That means less hardware, fewer SQL licenses, and fewer instances to manage.