Tag Archive: iscsi

How Big is Your Pipe? Check Out the Bandwidth Reference Poster

Do you know how much bandwidth you have from your SQL Server to your storage? Are you clear on what all the options are and how they compare?

If you’re not sure, don’t worry. In this blog post I’ll explain the basics and link you up with a poster that will make everything more clear.

How Fast is That Connection?

Check out the Bandwidth Reference Poster

Check out the Bandwidth Reference Poster

The first thing to know is that “Gigabit” is NOT the same as “Gigabyte”.

When I talk to clients using SAN storage with their SQL Servers, I find that usually the connection speed and type is one of these:

  • 1Gb iSCSI
  • 4Gb Fibre Channel

Notice the small ‘b’ in each of those? That means ‘Gigabit‘. This isn’t obvious to most people because of the way this is commonly said out loud. Most people say “One Gig Eye-Scuzzy” or “Gig-E” (the E is for Ethernet) for the first option, and “Four Gig Fibre” for the second option. Based on the “gig” in there, it’s easy to think that this connection type can transfer 1 gigabyte of data per second.

That’s a long way from the truth. We’re talking one gigabit per second. That’s 1 billion bits. That sounds like a lot until you do the math. There are 8 bits per 1 byte. If we translate 1 billion bits per second into megabytes, we have a theoretical maximum of transferring only about 125 megabytes/sec through a 1Gb iSCSI connection. That’s also theoretical— in the real world, we aren’t going to get that much. Even if we could, when it comes to modern databases 125 megabytes/sec is a pretty tiny straw to slurp gigabytes and gigabytes of data through!

Why is 1Gb Ethernet So Common?

I find clients using 1Gb iSCSI a lot— a few are using 10Gb iSCSI, and others use fiber channel, but there’s still a lot of 1 Gb iSCSI out there. Looking at the comparatively tiny size of this pipe on the chart, that might seem pretty strange.

The use of 1Gb connections is because of cost. Historically, 10Gb Ethernet was super pricey. In 2002, the per-port cost of 10Gb was around $39K, compared to $1K per port for 1Gb. These days, you’re looking more at around $750 per 10Gb port— but lots of companies still have older equipment around. Change, like 1Gb iSCSI, is slow.

There’s Often More to the Story

If you have performance problems, don’t go lighting a fire in your storage administrator’s office immediately after looking at the Bandwidth Reference. There are lots of things to factor in to get to the bottom of a performance problem, and the connection speed to storage is just one of them.  How many connections do you have? Can you use multi-pathing? How fast is your storage? Is storage really your big bottleneck? There’s lots to dig into.

Also, this is only the interface bandwidth.  If you’re using a single magnetic hard drive doing random reads, it doesn’t really matter what interface you’re using, because you can’t fill a USB2 pipe.  This chart matters most when you’re using multiple drives in a RAID array or when you’re using SSDs. (Not using RAID for your databases in production? Maybe the fire isn’t such a bad idea.)

To gets started, maybe just start some friendly conversations to figure out what your infrastructure is like.

Why is Memory on the Poster?

I like the Bandwidth Reference because it illustrates something else besides how slow some of the commonly used connection types are.

Check out the theoretical maximum bandwidth for memory. The bandwidth for memory is so big that 40% of its pipe needed to bend to fit on the page! This is staggering to think about in terms of application performance. We know logically that performance is better if we don’t have to read from disk, but this graphically shows how much faster that can be.

Remember one more thing, too– you can get these same speeds reading data from memory in more places than just your database server. You can also read from data cached in memory on your application servers without even talking to the database. Those are the fastest queries of all.

Download the Poster

To get the full sized goods, you just need to create a free login to our site. We promise not to share or sell your information with others. Download the poster here.

Kendra Little

Kendra specializes in high availability and performance tuning. She is a Microsoft Certified Master in SQL Server-- the highest technical SQL Server Certification available. Kendra loves databases and software development more than long walks on the beach. Those cartoons in her blog posts? She draws 'em all. Read more and contact Kendra.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Iomega StorCenter PX4-300d NAS Review: iSCSI Monster

I wanted to love this monster from the moment I read the spec sheets:

Iomega StorCenter PX4-300d NAS

Iomega StorCenter PX4-300d NAS

  • Network attached storage device with 4 or 6 hot-swappable drive bays
  • Available empty (so you can bring your own drives, including SSDs)
  • iSCSI server with 2 network ports, jumbo frame support, VLANs
  • Official VMware ESX/ESXi, Hyper-V, Windows DFS compatibility
  • RAID 0/1/5/10
  • Cloud support – automatically copy files to Amazon S3, Mozy, or other Iomegas over the Internet
  • External USB3 drive support (for leftover USB hard drives)
  • Insane number of home media support options including BitTorrent downloading, Time Machine backups for Apples, Bluetooth, automatic uploads to Facebook/YouTube/Flickr, recording server for Axis/Panasonic/D-Link webcams
  • Quiet (31dBa max) and low power (based on an Intel Atom CPU and 2GB of RAM)

The full feature list is ridiculous – it’s absolutely everything I needed for my VMware lab and my backups.  At around $700 from Amazon for the diskless version, I couldn’t resist.  I wouldn’t recommend buying the versions that come populated with hard drives – if you ever need to replace the drives, you’re in for a rough time, and oddly, the bring-your-own-disk version doesn’t suffer from that issue.

Choosing Drives and RAIDs for the PX4 and PX6

As of this writing, the list of officially supported hard drives is pretty short:

Storage pools in the PX4/PX6 have to all be the same size and speed, and I didn’t really need performance, so I chose to go with four of the Hitachi 3TB drives.  With those drives, RAID 5 would give me 9TB of usable storage, and the possibly-faster RAID 10 would give me 6TB.  I wouldn’t recommend the 2TB drives for a reason that’ll be clear shortly.

PX6 users have 6 drives to choose from, so in that environment, it might make sense to go with four magnetic hard drives and two solid state drives.  This would allow two tiers of storage: a blazin’ fast SSD mirror, and a bigger/slower RAID 5 pool.  With VMware ESX/ESXi’s Storage vMotion, we can move virtual machines back and forth between the two RAID pools without taking the VM down for a reboot.  It’s a fairly inexpensive way to get tiered storage, but with just 128GB in the fast pool, I’m not sure how useful this would be in practice.

Pluggin’ in the N: Network Attached Storage

iomega PX4-300d Control Panel

iomega PX4-300d Control Panel

The PX4-300d comes with the basics: power brick, one Ethernet cable, and the management tools CD.  After adding in drives and plugging it in electricity and Ethernet, the control panel displays the IP address it fetched from DHCP.  Fire up a web browser, go to that address, and you’re going to be impressed with the user interface.  You can even test drive the Iomega StorCenter control panel online.  (No, that’s not my Iomega, and no, you can’t delete data.  I tried.)

For the first minute or two, Iomega impressed the heck out of me.  The device could fetch its own firmware upgrades over the Internet, and yes, it was up-to-date.  I went into Drive Management, and sure enough, it offered a really easy GUI to configure RAID levels.  I picked RAID 10 and clicked Apply, but Iomega warned me that I hadn’t chosen any drives yet.  I’d missed the subtle little visual checkboxes inside each hard drive in the GUI, so…

I need to stop here and tell you a little about myself: I like to break things.

I didn’t say I like to take things apart and put them back together – oh no.  I just like to find new ways to break ‘em.  I take an evil satisfaction out of knowing somebody, somewhere didn’t test their code.

It's web scale!

RAID 10 with 3 Drives?

So I did what I do – I checked three boxes, chose RAID 10, and clicked Apply.

As far as I know, there’s not a way to perform RAID 10 with 3 hard drives (it requires an even number of drives) but the PX4 happily started initializing the array.  I sat there absolutely dumbfounded – this wasn’t a small bug, but a giant, ugly, monstrous bug.  I had no idea what the PX4 might be doing to the disks behind the scenes or whether I’d have any redundancy whatsoever.

I wouldn’t be so freaked out about this if Iomega wasn’t owned by EMC, one of the biggest, most reliable companies in the storage industry.  I had instant flashbacks to the click of death, the nasty sound Zip drives made before they crashed, resulting in a class action lawsuit against Iomega.  Was Iomega back to its old tricks of cutting costs at our peril, or were they up to EMC’s quality standards?  I took a deep breath, pretended I never saw it, and deleted the array.  I set up a four-drive RAID 10 array, decided to let one bug slide, and pressed on.

While the array is initialized, the Iomega’s LCD display and banners across the top of the web UI both warn the user that performance is degraded – very nice touch.  As the array is initialized, you can continue to use the storage array, and even write data to it – again, nice touch.  However, the initialization process takes hours – I left mine running overnight – which means I wouldn’t recommend the 2TB drives.  A PX4 with 2TB drives is $1,165, and with the 3TB drives it’s $1,405 – just $240 more for 50% more storage.  Yes, you could upgrade the drives later, but it’s going to take a loooong time to swap out each drive one by one and let the array rebuild.

Some Server Changes Require Reboots

The only way to win is not to play.

Restart Required

As the array initialized, I started wandering through the web control panel setting things up.  I changed the name to LittleBlackBox, and I was taken aback when the PX4 asked to reboot itself.  Really?  Just for a name change?  Okay, well, alright, nobody was on the array yet anyway.

Next up – configure remote access.  The PX4 will connect to a dynamic domain name service so you can use a simple DNS name to access your data from anywhere.  Sounds good, so I set it up and – you guessed it – reboot required.

Next up – configure iSCSI and jumbo frames.  This one at least didn’t require a complete NAS reboot, but it did warn that “This may take a few minutes to complete.  Anyone currently accessing this device will be disconnected.  Do you want to continue?”

The Problem with Rebooting an iSCSI NAS

NAS reboots aren’t a problem for some home users.  If iTunes stops working for a few moments, or my pictures stop uploading to the cloud, life goes on.

In a business or virtualization lab environment, it’s a massive problem.  VMware will be storing the virtual hard drives for several running machines on it.  In order to reconfigure many settings on the PX4/PX6, I have to:

  1. Shut down all of my virtual servers
  2. Shut down VMware
  3. Restart the Iomega and wait for it to come up
  4. Start up VMware
  5. Start up my virtual servers

This is a total showstopper in a corporate lab environment where multiple people might be playing with the device.  I simply wouldn’t be able to count on junior sysadmins not changing settings on the Iomega, triggering a reboot, and losing all of my virtual servers.  I would have to tightly control security settings on the NAS, but the only security option is a checkbox for administrative privileges: either you’re in, or you’re not.

That NAS is a Monster, M-M-M-Monster

Or was that philanderer?

Famous Philosopher

Philosopher L. Gaga once said in a poem entitled “Monster”:

I’ve never seen one like that before
Don’t look at me like that
You amaze me

While she was referring to crazy yet well-endowed gentlemen, I’m sure she would agree that the PX4-300d is just such a monster.  Its feature list is the size of a baby’s arm, but sometimes it’s got the business logic of a weiner.

The good news is that it’s got killer qualities for a virtualization lab – or perhaps even a small business’ virtualization needs.  The bad news is that it doesn’t have the stability or testing to back it up.

I was heartbroken.  I’d really wanted to recommend this storage device to small businesses for their staff to learn virtualization, storage vMotion, and perhaps even as a backup target.  With the current version of firmware, though, I just couldn’t do it.  With that in mind, I gave up on testing the network card failovers (which do work at first glance), multipathing (which doesn’t – more on that later), the speed differences with jumbo frames, and anything reliability-related.  For now, it’s just a good device for geeks to use in their labs and homes, so I’ll focus the rest of the review on that.

Device Features: Shares, Apps, Time Machine, BitTorrent, More

Onboard storage is set up in a hierarchy:

  • Drives are grouped together in pools (like 2 drives in a RAID 1 pair or 4 drives in a RAID 5).  Pools are a fixed size.
  • Pools are carved up into multiple volumes.  Volumes are a fixed size.
  • Volumes are carved up into multiple shares.  Shares are thin provisioned.
  • Applications are configured at the share level.

So in my PX4-300d, I have:

  • Storage pool – 4 drives in a RAID 10 for 6TB of usable space
  • “Media” volume – a 1TB volume that lives in my storage pool
  • “Torrents” share – a thin provisioned share in the Backups folder.  It starts at zero size, and can grow to whatever size of files I dump in there – up to 1TB.  I can access the Torrents share as a folder in Windows or on the Mac.
  • The Torrents onboard application added a Download folder in the Torrents share.  I can copy any torrent file into this folder, and the Iomega begins downloading it.
I'm in ur tubez, downloadin ur questions.

Torrent Download Details

The application user interfaces are designed by geeks, for geeks: they’re just good enough to be point-and-click usable, but not good enough that I’d want to walk family members through configuring or troubleshooting them.  For example, in the Torrent configurations screen, there’s a Port box.  You can manually configure a port or use the automatically supplied one, but you can’t tell if it’s actually working.  There’s no “test the router” functionality built in, so I have no idea if uploads are working or not until I start seeding a torrent.  There’s edit boxes for Maximum Download Speed and Maximum Upload Speed, but there’s no scale – is it KB/sec or MB/sec?

The apps have just enough capabilities to say they work, but not much more than that.  Modern BitTorrent clients all have scheduling setups so that you can transfer more at night and throttle back the sharing during the day – not here.

The Amazon S3 sync app will upload your files to S3, but it won’t delete the ones that get deleted on the NAS, thereby making your storage bill steadily increase.  If you use it for, say, SQL Server offsite backups, you would want to reuse your backup file names in order to get a 7-day rotation in the cloud.  You’d run into a separate issue anyway – S3′s max file upload size is 5GB.  Any larger files just don’t get uploaded, and you don’t get an alert.  No upload/download throttling or time-of-day scheduling here either – your bandwidth will just slow to a crawl as new files are added to S3.

Size Matters

Time Machine File Sizes Not Updated

Time Machine works wonderfully as a backup target, but the user is presented with two cryptic fields: Apple Network Hostname and Ethernet ID.  The network hostname comes from your Mac’s System Preferences, Sharing, click Edit, and it’s the part you can edit.  The Ethernet ID comes from going into Terminal, type ifconfig, hit enter, and look for en0 – the next line says ether, and copy/paste the characters to the right of that.  The Iomega doesn’t tell you any of this.  The only thing it does tell you is the Time Machine backup folder’s size, a constant 173MB, and even that is wrong.  After several days of backups, the folder sizes still showed incorrectly on the Time Machine panel of the Iomega.

But it works.

At least, I think it works.

And that’s what makes this review so hard.  When the control panel tells me it’s configuring a RAID 10 array with 3 drives, I know it’s wrong.  A basic error like that shakes my confidence in the entire unit.  Same thing with the incorrect Time Machine folder sizes, and the wacko configuration screens.  If I can’t trust what it’s showing me, how can I trust what’s happening behind the scenes?  I’m not sure.  This doesn’t bother me too much for home media backups, but it would bother me a lot for running my virtual machines.

Is the Iomega PX4-300d the Best VMware Storage Server?

Like MJ, I keep it in the closet.

My home VMware lab: HP Microservers and the Iomega PX4-300d

Most business iSCSI network implementations involve a completely separate logical network for iSCSI – separate IP addresses on a separate subnet.  For example, my home network is on 192.168.37.x, so I might use 192.168.47.x for my iSCSI network.  The iSCSI traffic is kept away from the regular network.

Most business iSCSI setups also involve redundancy: the storage device is plugged into the network with at least two network patch cables plugged into two different network cards.  If either one fails, you’re still able to talk to the storage.

At first glance, the PX4 can handle either one of those requirements, but not both.  If you want two separate logical networks, then you probably want to isolate the iSCSI traffic completely.  You can configure one of the PX4′s network ports into your management network (like 192.168.37.x) and plug the other into an iSCSI network.  When you do that, you just lost redundancy.  If you choose instead to have both of the PX4-300d’s network jacks plugged into the same network, that network is going to need to see the outside world if you want to use any of the PX4′s home-media-savvy features like BitTorrent.

This is where the good monster comes in again.

This Good Monster Has VLAN Support

This NAS supports VLANs – multiple virtual network subnets attached to the same network card.  Imagine an incoming network packet that finds its way to your server, and it’s got a tiny part at the beginning saying, “I’m coming from Virtual LAN #1.”  Your operating system would need to understand that it’s attached to a certain subnet and route it to Virtual Network Card #1.  The next packet might come in saying, “I’m coming from Virtual LAN #2,” and your computer would understand that it’s part of your Virtual Network Card #2 – the one for iSCSI.

Granted, your one network cable is only so fast, and we can’t stuff 2Gb of traffic into a 1Gb bag patch cable.  However, this does let us segregate network traffic at the switch level so that your chatty iSCSI traffic doesn’t overwhelm your regular network, and your chatty BitTorrent client traffic doesn’t overwhelm your iSCSI storage network.  While it is indeed delicious to get your chocolate in my peanut butter, it’s not nearly as delicious to get your BitTorrent in my iSCSI.

VLANs require a savvy operating system like VMware ESX/ESXi and a VLAN-capable switch.  I chose the $125 Cisco SLM2008-T because it supports VLANs, jumbo frames, has 8 ports, and it’s cheap.  Cisco switches have a reputation for being difficult to administer, but this one comes with a pretty good web control panel.  The setup process of putting in VLANs, jumbo frames, and ESXi configurations is a good idea for a future blog post, but suffice it to say that between Iomega’s web UI, Cisco’s web UI, and the vSphere Client user interface, you can be up and running with a very real-world-ish lab setup in under an hour – for some values of “running.”

Here comes the bad monster again – users can’t exclude network interfaces from iSCSI use.  Every time VMware rescanned the iSCSI adapters, the Iomega happily reported back that iSCSI services were available from every single IP address it owned.  I wanted to just do iSCSI over one network subnet, not both – no can do.  After pulling my hair out for a few hours, I threw in the towel and switched to NFS.  It worked the very first time I tried it, and it came with a nice perk: the StorCenter’s LCD display panel actually reflects the right amount of used space used on NFS volumes.  iSCSI volumes show up as completely full even if there’s not a single file on ‘em.  (That’s not the device’s fault, but users won’t know that.)

That’s probably a good lesson for StorCenter users: the features that require zero parameters are easy, and they work like a champ.

How Fast is This Cheap NAS?

They WILL vary.

Your mileage may vary. (Just one of dozens of test passes.)

Geeks love to tweak parameters.  I want to set the stripe size, caching, NIC load balancing, and flux capacitor voltage for every storage device.  That’s not what the StorCenter PX4/PX6 is about: it’s just, uh, storage.  Just as the other LifeLine apps don’t have much in the way of parameters, the iSCSI app checks just enough boxes to work – but that’s where the fun ends.

Most of my Windows-based iSCSI tests were able to saturate a 1Gbps Ethernet link with reads or with big sequential writes, and small or random writes ran around 10-60 MB/sec.  I was surprised, though, that no matter what tricks I played with multipathing or multiple iSCSI volumes striped together, I just couldn’t get this thing to blow past a single NIC’s throughput.  The lack of network card performance metrics on the Iomega made it a little tricky to troubleshoot, but after I checked the Cisco switch metrics, I got proof: the iSCSI traffic was only sent back through one network card on the Iomega – specifically, NIC #1.

I can write iSCSI data to both of the PX4′s network cards simultaneously.  They just won’t send data back from both simultaneously – at least, not when they’re both on the same subnet.  Maybe by getting even fancier with the multipathing setup and putting the two network cards on two different VLANs, in two subnets, I might be able to break past the 100 MB/sec read speed limit.  (For more about multipathing, check out my SAN Multipathing series.)

But you know what?  100MB/sec is fine for me.  See, if I really needed speed, I would have filled this thing with SSDs to begin with.  Solid state drives excel at random access, and that’s what every Iomega StorCenter NAS is going to end up doing – lots of random access.  Multiple VMs accessing the same LUN, BitTorrents being transferred, MP3s being played, these little devices are a party in a box.  The drives are going to be worked hard, and I bet for most people, the real speed limit will be the random access speed of the drives anyway.

But while troubleshooting storage performance multipathing, I ran into the bad side of the monster again.  I unplugged one of the Iomega’s two network cables, and I didn’t get any warnings whatsoever.  The PX4 didn’t show any errors on the LCD display or the web control panel, and it didn’t even notify me via the built-in email alerts.  I had to dig into the network screen to even figure out that one of the cables was unplugged.  Upon reconnecting the cable, the Iomega autonegotiated to 10Mbps (not 100, not gig, but 10) half duplex.  No warnings were shown on the control panel for that, either, and to make matters worse, you can’t set the Ethernet speeds.  It’s autonegotiate or nothin’.

Bottom Line: It’s a Little Monster Alright.

So close, but yet, so far...

Iomega PX4-300d: 95% There

The Iomega PX4-300d NAS seduced me with its long, strong…feature list, and I’m willing to overlook the wild infestations of crabs bugs for my lab at home.  It’s the first NAS I haven’t returned back to the shop in less than 72 hours.  Like the philosopher said:

Look at him, look at me
That boy is bad, and honestly
He’s a wolf in disguise
But I can’t stop staring in those evil eyes

Who should buy the StorCenter PX4/PX6? Home users that want one quiet, capable box to sit in a closet handling backups, media, BitTorrents, uploading photos to the cloud, and other menial chores.  Yes, you could build your own more-capable solution for less money, but it won’t be as point-and-click easy as the Iomega.  IT, DevOps, and developer managers should also pick up one of these as a reward for a well-performing team.  Throw one of these under a cubicle and for less than the price of a good workstation, the entire team now has an iSCSI sandbox and shared MP3 storage off the domain and away from the corporate IT overlords.

Who shouldn’t buy it? I wouldn’t recommend the PX4/PX6 in a business environment for anything other than a lab – at least, not until versions of the firmware come out that fix the glaring UI bugs and stop users from rebooting the NAS.  I would be very uncomfortable to go into a small business as a consultant, sell them a shared storage setup using a StorCenter PX4/PX6, and walk away.

Can they fix these issues with firmware updates?  Yes, but only if they test the new firmware updates better than they’ve tested so far, and as of August 2011, it’s not looking good.  After applying a firmware update to fix the VMware multipathing issue, I received this disturbing email from Iomega:

Thank you for downloading the recent firmware update for your Iomega StorCenter px. After release, we identified an issue with growing or expanding storage pools with the v 3.1.10. 45882 update.  If you have not yet applied the update to your system, please wait. We will be releasing a new version of the firmware that resolves the issue soon.  If you applied the update, you should not experience any issues unless you expand or modify the size of a storage pool.   If you do experience any issues with a storage pool, please reply to Iomega Technical Support using this incident number….

M-m-m-monster…

If you decide to buy it, you can throw me a few coins by buying the Iomega PX4-300d via my Amazon link or the 6-drive version, the PX6.  And hey, it’s in stock for Prime members, so you could have it tomorrow – plenty of time to play with it over the holiday weekend. I’m not sayin’, I’m just sayin’.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

My Weekly Bookmarks for October 16th

Here’s my bookmarked links for the week ending Friday, October 16th:

PASS Election Links

PASS Summit Links

SQL Server Links

IT Links

The Junk Drawer

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

My Weekly Bookmarks for October 9th

Here’s my bookmarked links for October 2nd through October 9th:

SQL Server Links

Tech Links

The Junk Drawer

  • I Love That Game – Brilliant criminal minds at work.
  • Twitter Data Analysis: An Investor’s Perspective – A bunch of oddball stats about Twitter users and their histories.
  • Will Work for Whuffie? – Why you have to charge fees for speaking engagements when you hit a certain level of fame. (No, I’m not there yet, hahaha, but even if I was, my speaking engagements are free because I’m a service of Quest Software. No, not that kind of “service,” buddy.)

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

My Weekly Bookmarks for August 28th

Here’s my bookmarked links for August 23rd through August 28th.  I’m using an automatic plugin to build this list, and I can see that this probably isn’t going to work – I just found way too many things interesting in one week, and it doesn’t break stuff out into categories.  Blogger fail.  Here it is anyway as an example of What Not To Do during my Better Blog Week:

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Dell EMC AX150i review

Dell EMC AX150i

Dell AX150i

The iSCSI EMC AX150i is resold by Dell, and refurbished versions are available pretty inexpensively through the Dell Outlet. We just picked up our second AX150i with 12 500gb SATA drives for around $6,000 total, or about $1,000 per raw terabyte. It’s a great deal for lab or development storage, but there are a couple of gotchas that I haven’t found in other reviews.

The AX150′s Drive Pool Setup Limitations

The AX150i stores its operating system on the first four drives (bays 0, 1, 2, 3). Those 4 drives therefore have less available capacity than the other 8 drives in the AX150i. Those drives cannot be used as hot spares, either, because of their specialized roles.

This breaks the AX150′s drives into the following categories:

  • Disks 1-4: some space consumed by OS, can’t be hot spares
  • Disks 5-11: full amount of free space
  • Disk 12: hot spare (could be any disk number, but I’m picking 12 for this example)

If the user tries to create a disk pool, and tries to mix some of disks 1-4 with disks 5-11 (like creating a 6-disk array with disks 1, 2, 3, 4, 5, 6), the AX150 throws out a stern warning. It will allow the configuration, but the warning is pretty ugly.

So if the user can’t mix drives from those 3 groups (OS, empty, hot spare), that basically leaves the following possibilities:

  • One pool with disks 1, 2, 3, 4 – can either be raid 5 (roughly 1.5tb capacity) or raid 10 (1tb capacity)
  • One pool with disks 5, 6, 7, 8, 9, 10, 11 – an awkward total of 7 disks, meaning raid 5 (3tb capacity) or only use 6 disks in a raid 10 and get 1.5tb capacity plus an extra hot spare
  • One hot spare (or two, if disks 5-10 were used as a raid 10)

Total config space for raid 5 is 4.5tb, and for raid 10 is 2.5tb. That space quantity is fine, but the hard-coded setup limitations on which disks can be grouped together are a pain – especially when we’re only dealing with 12 drives.

The AXI150i Has No Load Balancing

The AX150i has two iSCSI ports, and it does support multipathing with the stock Microsoft iSCSI initiator. I’ve successfully set up both of the iSCSI ports on the same switch, set up two network cards on a Windows server with the MS iSCSI initiator, and then pulled various network cables out during I/O activity. Sure enough, the drives fail over without loss of connectivity or data. To me, that’s an astounding bargain at the sub-$10k price point.

However, with one Windows server and one AX150i, I haven’t been able to break the 90mbps bottleneck – meaning, I don’t get more than one network card of throughput. I’ve tried multiple disk pools, tried multiple drives, different drives on different network ports, and I haven’t been able to figure out how to get it to use two full network ports.

This is not a huge problem at this price point – I’m thankful enough that I’ve even got failover in an array this inexpensive. However, consumers need to be aware that two iSCSI ports doesn’t mean two 1gb network cards with 100% saturation.

It’s Not Expandable

Dell/EMC don’t claim this model is expandable, but this needs to be emphasized to the prospective buyer. Shops with two or more AX150′s can’t combine them, and can’t migrate data from one AX150 to another. If there’s a small amount of free space on two AX150′s, it can’t be combined to create a single LUN.

Again, not a big problem at this great price point, but something to be aware of. This feature is available at higher price points from companies like EqualLogic (now owned by Dell) and LeftHand Networks.

And Yet: A Big Winner At This Price Point

Shops that haven’t invested in shared storage yet can get their feet wet with an AX150 without a big capital commitment. I’d recommend it for a shop that isn’t sure whether or not they’ll go with iSCSI or fiber down the road, or if they’re just not sure about shared storage, period. This class of storage is cheaper to get into – and out of – than a LeftHand chassis. An AX150 can be had for under $10k, whereas the LeftHands and EqualLogics run at least twice that much. Granted, they offer twice as many features and much better scalability.

We took the approach that these are for development sandbox use only, never production. Our VMware lab farm is hooked up to an AX150, and so is my SQL Server data warehouse testbed. It’s a testament to their ease of use that I’m always tempted to slap a production array on one just because we’ve got the extra space.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube