Download OCZ Storage Solutions ZD-XL SQL Accelerator

OCZ ZD-XL SQL Accelerator
Integrated Flash Hardware á Software Solution for SQL Server
U N | eas @ S O | S erver The ZD-XL SQL Accelerator is a tightly integrated, plug-n-
play flash acceleration solution optimized for Microsoft
P © ri ormance SQL Server deployments. As the culmination of a tightly
integrated hardware and software solution, ZD-XL
provides end-to-end data path integration. Its
acceleration software, driver, firmware and hardware are
uniquely optimized to provide robust, streamlined
performance.
The ZD-XL addresses SQL Server database applications to
ensure that the data is right, relevant, and readily available
on SSD flash when SQL Server needs it. Plugging
The ZD-XL SQL Accelerator drives TCO savings with seamlessly into existing or new SQL Server installations, it
optimized performance and minimized system DRAM provides on-host application-optimized flash caching for
requirements, enabling the use of cost-effective commodity SAN or DAS DB volumes, enabling data to be accessed with
storage for capacity. the highest possible I/O performance.
° Plug-n-Play deployment Featuring step-by-step implementation wizards, the ZD-XL
o guides DBAs so they can optimally benefit from the flash
* Optimized OLTP and OLAP flash caching
* Flash volumes for tempDB and logs
resources provided by the acceleration card.
One click creation of all flash volumes allows ultra-low
* (Cache warm-up analysis and scheduling latency access to tempDB and columnar indexes. While at
Best practice deplovment wizard the same time, OCZ’s Direct Pass Caching Technology
° | WIZ
Р ploy 5 offers optimized acceleration caching policies for DAS and
* Direct Pass Caching Technology SAN volumes running analysis or transactional SQL Server
- DAS and SAN DB volume acceleration loads.
The ZD-XL SQL Accelerator further provides a unique cache
Á Dd warm-up and analysis mechanism that enables monitoring
” Database
q Application y and preloading of scheduled data into the cache making
sure the right data is available at the right time to SQL
Server analytical loads.
* A disconnected
acceleration stack
affects performance
and endurance
y ЕЕ
Database
h
k,
Application
Dl
o A
AE
Caching
Policies
ÿ Unoptimized | w Dx. sal
f NY ccelerator
HW
* Database performance,
flash latency, and
endurance optimized
through tight integration
>
rm
an
pi
о
==
Q
[Ce]
Ф
>
0
0
1
Ф
==
Q
—
о
==
wn
Ф
=
Ф
um
OCT enterprise
OCZ ZD-XL SQL Accelerator
Integrated Flash Hardware á Software Solution for SQL Server
Optimized SQL Acceleration The ZD-XL SQL Accelerator provides optimized application-aware caching
policies for SQL Server OLAP and OLTP loads. Optimized policies ensure the highest benefit from flash
resources by closely monitoring the application data access DNA.
Data Warehouse Query Completion Times
Increase SQL Server Query Performance by 25X
Top Supplier
Promotion Effect
Market Share
Shipping Priority
Orders Waiting
Large Volume Customer
Product Profit
Supplier Volume
0 1,000 2,000 3,000 4,000 5,000 6,000 7,000
E Accelerated with Direct Pass Caching E RAID O HDDs
OCZ ‘Direct Pass Caching’ Technology The ZD-XL SQL Accelerator’s tight hardware and software integration
allows its advanced application-optimized caching engine to run in tangent with streamlined flash drivers. The unique
acceleration architecture is powered by OCZ’s Direct Pass Caching Technology offering optimized hit ratios with
ultra-low latency access to flash.
Windows Server
Microsoft Optimized SQL
e SQL Server Server acceleration
policies/management
Windows Kernel
Optimized SQL Data Path Cache Splitter
Out of data path
updates &
N IC = BA optimizations
2
OC enterprise
>
rm
an
pi
о
==
Q
[Ce]
Ф
>
0
0
1
Ф
==
Q
—
о
==
wn
Ф
=
Ф
um
OCZ ZD-XL SQL Accelerator
Integrated Flash Hardware á Software Solution for SQL Server
Plug-n-Play into Existing SQL Deployments The ZD-XL SQL Accelerator seamlessly accelerates existing SQL
deployment by caching the hot data from existing DAS and SAN DB volumes on accelerated flash resources.
Acceleration card resources are seamlessly divided between a flash caching pool and on-host flash volumes.
( в
Windows Server Failover Cluster (WSFC)
WSFC Resource Group for Availability
Group
Management
Node 01 Node 02 Node 03
SQL Server SQL Server SQL Server
Instance Instance Instance
ZD-XL ZD-XL ZD-XL
Accelerator Accelerator Accelerator
Primary Secondary Secondary
Replica Replica Replica
Availability Group
SQL Acceleration Deployment Wizards Implementations wizards guide the DBA through best
practice deployment of flash for SQL acceleration, enabling quick set-up and optimized acceleration of
existing deployments.
Capacities & Form Factors Supported Operating Systems
« HH PCIe 600 GB « Windows 2008 R2
+ FH PCle 800 GB * Windows 2012
< Sia ° FH PCIe 1.6 ТВ
В»,
Supported Application Versions
Microsoft SQL Server 2012
Microsoft SQL Server 2008
OC ente rprise © 2013 OCZ Technology Group, Inc. All rights reserved. OCZ may make changes to specifications and product descriptions at any time, without notice.
>
rm
an
pi
о
==
Q
[Ce]
Ф
>
0
0
1
Ф
==
Q
—
о
==
wn
Ф
=
Ф
um