Optimize SQL server management with Pure Storage

Running SQL Server on all-flash crushes storage latency, enabling 3-5x better transactional throughput and dramatically simplifies operations.

SQL Server diagram

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 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.

SQL Server diagram SQL
MatterSight logo

“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:

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 complex storage calculations. Just create a volume and move your databases, logs and tempdb files for instant performance gains. Done. Fast.

whitepaper icon
White Paper

Microsoft SQL Server 2012 Reference Architecture

Any SQL Block Size.

In addition to understanding your storage LUN layout, fine-tuning the Windows Server block size is usually critical to ensuring performance, so that Windows blocks aligned harmoniously with the storage geometry. Pure Storage's 512-byte virtualization architecture means block alignment issues disappear. Just connect your storage to your servers and start enjoying your all flash storage!

whitepaper icon
White Paper

Pure Storage and Microsoft Windows Server Best Practices Guide

Virtualize SQL Without Fear.

Yes, you can with Pure Storage. Tier 1 databases typically drive highly random I/O, and are incredibly latency-sensitive… 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.