Optimizing SQL Server AlwaysOn Implementations with OCZ’s ZD-XL SQL Accelerator

Delivering Accelerated Application Performance, Microsoft® AlwaysOn High Availability and Fast Data Replication with the Mellanox® ConnectX®-3 EN Network Interface Card

Allon Cohen, PhD
Yaron Klein
Scott Harlin

Published July 2013

Introduction

OCZ’s new ZD-XL SQL Accelerator is designed to provide optimized and efficient flash acceleration for SQL Server environments through the tight integration of innovative hardware and software elements. This plug-and-play solution has earned the Best of Interop® award in the Data Center & Storage category through a potent combination of lightning fast flash performance, a unique cache mechanism that makes advanced and statistically-optimized decisions on what data to cache, and wizard-based implementation software that enables database administrators (DBAs) to setup caching policies that optimize application performance based on SQL Server workloads.

Utilizing the capabilities provided by SQL Server AlwaysOn technology, the new ZD-XL SQL Accelerator also has the ability to enhance complete high availability (HA) so not only can SQL Server environments function at the speed of flash, but in the event of planned or unplanned downtime, can continue operations from point of stoppage, retaining all of its data as if no downtime had occurred.

The SQL Server AlwaysOn environment is heightened through a collaborated effort with Mellanox® Technologies. The combination of the Mellanox ConnectX®-3 EN 40 Gigabit Ethernet (GbE) network interface card (NIC) with the ZD-XL SQL Accelerator delivers industry fast data replication for HA services optimizing SQL Server installations even further.

The purpose of this white paper is to describe how ZD-XL SQL Accelerator is optimized for SQL Server highly available environments delivering accelerated application performance with Microsoft® AlwaysOn functionality and fast data replication with the Mellanox ConnectX-3 EN NIC.

Table of Contents

  1. Introduction
  2. Accelerating SQL Server Performance
  3. High Availability Through SQL Server AlwaysOn
  4. Cutting-Edge HA Data Replication of SQL Server AlwaysOn
  5. Conclusion