What are you looking for ?
Infinidat
Articles_top

OCZ Adds ZD-XL SQL Accelerator

Integrated hardware/software with in 600, 800GB and 1.6TB PCIe SSDs

OCZ
Technology Group, Inc
. announced the availability of its
ZD-XL
SQL Accelerator
which was first showcased live at Interop
2013 and won the Best of Show Award in the Data Center and
Storage
category.

zd_540

This product is an
integrated hardware/software storage solution that accelerates and
optimizes SQL server database applications in enterprise
environments.

It includes a flash-based
PCIe SSD working in combination with acceleration and caching
software to deliver relevant SQL server data when the application
needs it. The GUI provides step-by-step implementation wizards
that guide database administrators through best practice models of
its flash-based resources to deliver easy deployment into SQL Server
environments.

The architecture exposes its
PCIe-based on-host flash as both local and cache volumes, and
distributes random database workloads in parallel between all of its
available flash to provide up to 25 times improved database
performance depending on the application load. The ability to
partition its flash between local volumes and cache enables data
files, such as tempDB, to benefit from high flash performance while
hot database data is cached to flash for availability by SQL Server.

"Plugging seamlessly
into existing or new SQL Server installations, our new ZD-XL SQL
Accelerator leverages both our SSD hardware and software IP to
provide application-optimized flash caching load volumes that enable
data to be accessed with the highest possible I/O performance,
"
said Ralph Schmitt, CEO, OCZ. "We believe
that the industry is primed for this type of tightly integrated,
plug-and-play use-case acceleration solution that uniquely combines
software, driver, firmware and hardware into one robust and easy to
deploy high-performance SQL Server solution.
"

"By deploying ZD-XL
SQL Accelerator in our database servers, we reduced the run time of
key SQL Server jobs from 2.5 hours to 45 minutes, without replacing
our SAN,
" said Lars Ketting, ICT, Cartal
Rijsbergen Automotive
. "Along with these performance
benefits, the simple implementation wizards allowed us to easily
migrate from our test environment to deployment in our production
systems.
"

Direct Pass Caching
technology is a component of the accelerator as it selects what data
to insert into flash cache. The technology utilizes a data path
cache director, cache analysis engine, and policy-based algorithms
that enable DBAs to use pre-optimized SQL server-specific caching
policies. This decision-engine performs deep ‘out-of-band’
statistical analysis of both OLTP (transactional) and OLAP
(analytical) loads, making knowledgeable selections that ensure high
hit ratios of the most frequent and important hot data to cache
within the accelerator without having to perform analysis in the data
path itself.

Another feature is the
business-rule pre-warming cache engine and cache warm-up analyzer
that monitors SQL Server workloads and pre-loads the cache in advance
of critical, demanding SQL server jobs. It achieves this by
identifying repeated access patterns that enable DBAs to set periodic
time schedules to pre-load the cache. It assures that this data
resides on the cache at the exact time SQL server needs it.

It is designed to enable HA through SQL Server AlwaysOn technology, 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
the stopping point, retaining all of its data as if no downtime had
occurred.

The product is available in
three configurations supporting 600GB, 800GB and 1.6TB storage
capacities with service and support options available for each.

Articles_bottom
AIC
ATTO
OPEN-E