OCZ aims to improve SQL Server performance with new acceleration card

The company has tailored its caching algorithm for Microsoft's database

OCZ Technology has started offering to beta testers is ZD-XL SQL Accelerator, a card that uses solid state drive (SSD) storage to improve the performance of SQL Server databases.

For OCZ, the ZD-XL SQL Accelerator represents a new direction. Instead of of just offering a general platform, the product has been developed with just one application in mind. It is also OCZ's first entry into the Windows world.

"What we did was take our acceleration software we developed for VMware and Linux and tailored it for SQL Server," said Oded Ilan, general manager at OCZ Israel, when interviewed in the company's booth at the CeBIT trade show.

That work has included optimizing OCZ's caching algorithm to work better with the type of I/O that SQL Server generates, and allowing it to locate so-called hot zones in the database.

"The trick is really to make sure that you have the very latest and active data in the cache when you need it, and that is what our algorithm focuses on," said Ilan.

To make the product easy to use, the whole set-up is done using a wizard. It comprises of a flash PCI Express (PCIe) card and software dedicated to accelerating SQL performance in a Windows environment.

ZD-XL SQL Accelerator comes with either 1.6TB or 600GB storage. Because database sizes are increasing continuously, Ilan expects the larger version will be very popular. But the 600GB version's smaller footprint makes it a good fit for 1U servers, according to Ilan.

In general, users should expect between 5x to 20x performance improvements.

The beta testing has started, but OCZ is still looking for more enterprises interested in testing the product. It is expected to become generally available in May. Pricing has not yet been announced.

At CeBIT, OCZ also demonstrated the latest version of the its main product, VXL. In addition to caching and acceleration, the platform also comes with a number of storage features. The new version 1.3 includes a fault tolerant mode that allows a secondary VMware server to immediately take over if the primary one fails without the need for applications to reboot, Ilan said.

"Usually you need to implement a SAN for that to work. But here there is no SAN, instead there is one PCIe flash device in each server and with our software we have a synchronous mirror between the two of them over 10 Gigabit Ethernet," Ilan said.

The choice of 10 Gigabit Ethernet came down to its popularity and low cost.

Another new feature allows IT managers to pre-load the cache with critical data on a pre-determined schedule. The feature can be used by organizations that have a lot of users running virtual desktops, for example.

"The users all come in a at 8 o'clock in morning and that applies tremendous pressure on the disk, and here we show the acceleration you get when booting from the cache as opposed to the disk," Ilan said.

The software has a recording system to help decide what data to populate the cache with.

In addition to the SSD storage, VXL also uses a DRAM storage tier up front. A typical configuration includes a few gigabytes of DRAM and a few terabytes of flash storage.

"All of the hottest transient data hits the DRAM tier first, and if it's a read-write, read-write, read-write it may not even reach the SSD. That protects SSD layer from excessive writes and helps us get the best usage out of the flash storage," Ilan said.

Transient data includes database transactions. Products like VXL have made it possible to virtualize more demanding applications, like databases, as well, according to Ilan.

OCZ has just started shipping VXL 1.3.

Send news tips and comments to mikael_ricknas@idg.com

Join the newsletter!

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection

Tags databasesOCZ Technologycebitapplicationsserverswindows serverWindowshardware systemssoftwareoperating systems

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Mikael Ricknäs

IDG News Service
Show Comments

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Sarah Ieroianni

Brother QL-820NWB Professional Label Printer

The print quality also does not disappoint, it’s clear, bold, doesn’t smudge and the text is perfectly sized.

Ratchada Dunn

Sharp PN-40TC1 Huddle Board

The Huddle Board’s built in program; Sharp Touch Viewing software allows us to easily manipulate and edit our documents (jpegs and PDFs) all at the same time on the dashboard.

George Khoury

Sharp PN-40TC1 Huddle Board

The biggest perks for me would be that it comes with easy to use and comprehensive programs that make the collaboration process a whole lot more intuitive and organic

David Coyle

Brother PocketJet PJ-773 A4 Portable Thermal Printer

I rate the printer as a 5 out of 5 stars as it has been able to fit seamlessly into my busy and mobile lifestyle.

Kurt Hegetschweiler

Brother PocketJet PJ-773 A4 Portable Thermal Printer

It’s perfect for mobile workers. Just take it out — it’s small enough to sit anywhere — turn it on, load a sheet of paper, and start printing.

Matthew Stivala

HP OfficeJet 250 Mobile Printer

The HP OfficeJet 250 Mobile Printer is a great device that fits perfectly into my fast paced and mobile lifestyle. My first impression of the printer itself was how incredibly compact and sleek the device was.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?