PCIe SSD based SQL accelerator |
July 23, 2013 -
the general availability of its
Accelerator - an SSD
ASAP appliance - delivered as a PCIe SSD (600GB, 800GB or 1.6TB) and
bundled software - which optimizes caching of SQL Server data in Windows
environments - and can provide upto 25x faster database performance.|
functionality works through Microsoft SQL Server AlwaysOn technology, so that
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.
"We believe that the industry is primed for this type of tightly
integrated, plug-and-play use-case acceleration solution..." said Ralph Schmitt,
CEO - OCZ Technology.
Editor's comments:- One of the
differentiators in SSD caching products is the sophistication of their
behavior when viewed from a time basis. This is 1 of the
11 key SSD
symmetries - which I call "age symmetry".
In this respect
- a key feature of ZD-XL SQL Accelerator is its business-rule pre-warming
cache engine and cache warm-up analyzer that monitors SQL Server workloads and
automatically pre-loads the cache in advance of critical, demanding or important
SQL Server jobs. It achieves this by identifying repeated access patterns that
enable DBAs to set periodic time schedules to pre-load the cache.
product won Best of Show Award at an event called Interop in
|Here are some more articles and papers about the
ZD-XL which I found later
ZD-XL SQL Accelerator - by Allon Cohen and Scott Harlin
at OCZ - which among other things discusses the different requirements of
transactional and analytical loads with respect to optimizing cache policies.
that is critical to cache at one point in time may be useless at another, and
the selection of the best data to cache at each point in time is highly
dependent on current access statistics. A major benefit of the ZD-XL SQL
Accelerator is its advanced SQL Server policy-based algorithms that enable IT
managers to use optimized applicationspecific caching policies to make
knowledgeable selections of what data to store in cache"
||OCZ's 4th generation of PCIe SSDs - the Z-Drive
R4 is available in 300GB to 3.2TB capacities and is available in 2 standard
Both configurations support SLC or MLC
NAND flash memory with reduced write amplification to extend drive life. As with
all OCZ enterprise products, customer-specific configurations and functionality
are available upon request.
- a half height version designed for space constrained 1U servers
- and a full height version.
Controller Architecture supports the industry standard SCSI command set and
provides highly efficient performance aggregation, queue balancing and data
OCZ was the first oem to offer bootable enterprise
PCIe SSDs - in 2009 - thereby helping to open up new markets for SSD accelerated
- capacity options from 300GB to 3.2TB
- upto 2,800MB/s R/W throughput
- upto 500K IOPS performance
- power loss protection
- full speed encryption
- SuperScale Processor
- compatible with Windows 7, Windows Server 2008, and Linux Red Hat
|Here's something I found later about the Z-Drive
23, 2012 - OCZ
a new version (1.2 ) of its
cache and virtualization software - which provides high availability,
synchonous replication and enhanced VM performance across arrays of the
company's Z-Drive R4 PCIe