OCZ aims to improve SQL Server performance with new acceleration card

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

By , IDG News Service |  Hardware

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.

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Answers - Powered by ITworld

Ask a Question