Microsoft SQL Server

Learn How Fusion-io Helps
Microsoft SQL Server Databases DOWNLOAD KIT

Breakthrough Performance, Scalability, and Efficiency

Fusion's ioMemory eliminates database latency with a persistent, high-performance, high-capacity memory tier. In just minutes, you can install the device and configure Microsoft SQL Server to use it for tempdb, log files, or index files to triple performance. Or, if you've ever wondered what it would be like to fit your whole database in DRAM, ioMemory can deliver terabytes of persistent, high-performance memory per server.

Identifying I/O-Constrained SQL Server Databases

Improve Performance and Scalability

  • Enjoy industry-leading performance
  • Get the highest IOPS and bandwidth, with the lowest latency
  • Gain linear scalability
  • Take advantage of a simple and elegant design that eliminates the overhead of unnecessary hardware and storage protocols
  • Optimize application performance
  • Use Fusion's Virtual Storage Layer (VSL) to provide applications with direct memory access (DMA) to ioMemory NAND flash with the industry's lowest latencies
  • Maximize query performance
  • Fully utilize multi-core hardware and full PCI Express bandwidth
  • Maximize hardware instance usage; stop adding instances just for performance

Provide High Availability

  • Speed mirroring, log shipping, and failover
  • Dramatically decrease maintenance, service, and disaster recovery time
  • Perform maintenance without impacting performance
  • Meet service level agreements with less hardware

Virtualize and Consolidate

  • Virtualize even data-intensive databases
  • Reduce hardware, software, and operational costs
  • Simplify and speed deployment
  • Scale dynamically with the needs of the business

Empower Data Warehouses

  • Deliver the highest performance to your warehouse
  • Enjoy the flexibility of running reports and business intelligence at the same time
  • Reduce data warehousing costs

Improve ROI

  • Fully utilize multi-core hardware to get more performance from less infrastructure
  • Get higher performance from fewer hardware instances
  • Radically reduce power, cooling, and rack space needs
  • Greatly ease maintenance on software and hardware


If possible, put the entire database on one or more ioDrives. If not, try moving just the logs, tempdb, or select indexes and tables onto the ioDrive for performance improvement.

Easily Migrate to a Fusion Powered SQL Server 2012 and Achieve High Performance and Availability

New features in SQL Server 2012 give enterprises the means to easily implement scalable, high-performing, and highly available server-centric architectures. These architectures allow organizations to go beyond performance needs cost-effectively, without sacrificing the availability that mission-critical applications require.

ioMemory accelerates AlwaysOn

  • Speeds replication to enhance High Availability profile
  • Enables rapid failover for maximum resilience
  • Increases server workload so you can achieve full redundancy with fewer servers

ioMemory accelerates readable mirrors to provide,

  • Faster, deeper reporting & analysis with no impact on production
  • Unparalleled backup, recovery & maintenance with no impact on production

Example Architectures

More Information on Microsoft SQL Server 2012



SQL Server Learning Center