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!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags databasesserversoperating systemssoftwareapplicationsWindowshardware systemswindows servercebitOCZ Technology

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

Brand Post

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Aysha Strobbe

Microsoft Office 365/HP Spectre x360

Microsoft Office continues to make a student’s life that little bit easier by offering reliable, easy to use, time-saving functionality, while continuing to develop new features that further enhance what is already a formidable collection of applications

Michael Hargreaves

Microsoft Office 365/Dell XPS 15 2-in-1

I’d recommend a Dell XPS 15 2-in-1 and the new Windows 10 to anyone who needs to get serious work done (before you kick back on your couch with your favourite Netflix show.)

Maryellen Rose George

Brother PT-P750W

It’s useful for office tasks as well as pragmatic labelling of equipment and storage – just don’t get too excited and label everything in sight!

Cathy Giles

Brother MFC-L8900CDW

The Brother MFC-L8900CDW is an absolute stand out. I struggle to fault it.

Luke Hill

MSI GT75 TITAN

I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Emily Tyson

MSI GE63 Raider

If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.

Featured Content

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?