Does anyone have Experience with LeftHand's VSA SAN? [closed]

I am looking at re purposing some hardware and build out a virtual environment. I am looking to use the LeftHand VSA (Virtual Storage Appliance) to serve the local disks as a SAN to the virtual machines.

The heaviest app would be a Microsoft SQL database with 50 concurrent client connections, pulling light medical records.

Does anyone have any real world experience with the product and what is you take on it?

Before I talk about LeftHand's VSA specifically, I'm going to zoom out and talk iSCSI in general. If you're going to hook SQL Server up over 1 gig iSCSI, then your max storage bandwidth is 100MB/sec - fairly low. It's pretty easy to saturate that with a handful of hard drives. SQL Server lives and dies by IO speed, so as a result, I don't see a lot of production SQL Servers running entirely on iSCSI. I love iSCSI, don't get me wrong, but it's pretty easy to hit the bandwidth ceiling.

You can add multiple network ports and start doing multipathing, but you have to be careful: most multipathing solutions out there aren't really active/active, but active/passive. You can do some delicate setup operations and split out load - for example, use one array for your data, one for your logs, and use different network cards for the "active" pipe for each array. However, that's a manual setup, and you have to stay on top of that manually.

Now, let's talk LeftHand's VSA: not only are you facing these bandwidth limitations, but now you're going to lose some speed off the top due to the overhead of a software SAN implemented through virtualization. The network throughput is virtualized, the storage access is virtualized, and the cpu/memory is virtualized - whereas SAN gear is built from the ground up for IO speed.

Does it work? Absolutely. Is it as fast as conventional SAN gear? No, and in some cases, it's not even as fast as direct attached storage.

We did a trial of the VSA and decided against it; it performed poorly for SQL. If your usage for SQL is pretty light, it would work ok but there are much cheaper solutions.

Presumably you're looking at LeftHand for it's price. If so then I couldn't agree with Brent Ozar any more, SQL lives and dies by its latency and iSCSI is all about price/performance - not performance. I would look to an inexpensive FC SAN such as the HP MSA2000fc, I'd be surprised if it's much more expensive that the LeftHand (especially as you're dealing with HP already and they're very grateful of orders right now, expect big discounts) and will perform MUCH better today and in the future.