SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

It Depends

Add to Technorati Favorites Add to Google
 

Provisioning Storage

By Andy Warren in It Depends | 06-10-2008 1:59 AM | Categories: Filed under:
Rating: (not yet rated) |  Discuss | 443 Reads | 85 Reads in Last 30 Days |no comments

It's a rite of passage in our business that we have to learn the RAID levels, and I still enjoy the arguments about RAID-5 vs RAID-10, and it seems we still have to keep having the conversation about spindles vs space. But the world is changing with SAN's becoming very common, and many businesses now have a full time storage person, which brings us to the point of the post today.

Probably more than any other part of the business we're using to pushing hard for the hardware we need (or think we need) when it's time to buy. That's fair, because we probably demand more of the hardware than anyone else and don't have the luxury of scaling out like the web guys do. SAN's arent a miracle cure for performance, but the old rules aren't always the right rules for a SAN either.

Instead of demanding x drives configured in RAID x, what we should be doing is putting together a service level agreement (SLA) and sending it to our network team/storage team/SAN vendor, and in simple form it might look like this:

  • Require space provisioned as follows: Drive Z, 500g (data), Drive Y, 100g (logs), Drive X, 300g (backups)
  • Each drive specified must run on different physical drives so that if anyone one drive (letter) fails the others remain safe
  • Implement RAID 1, 5, or 10 for each of those drives.
  • Guarantee sustained IO rates as follows: Z:, 1000 IOPS, Y:, 250 IOPS, X:, 250 IOPS
  • Interface preferred is Fibre Channel, iSCSI is acceptable

Instead of telling them how to do it, we're telling them our requirements and letting them figure out best way to implement it (isn't that we want from people asking us for assistance?). We don't need to know or care that the storage is really a couple of cheap SATA drives set up in RAID 1 as long as we get our SLA. If they don't meet the SLA, well, someone has to fight that battle. If we didn't ask for enough, we revise the SLA based on recent operations and ask them to meet the new SLA.

Make them work for you, but let them figure out the solution!

Don't lose interest in storage entirely though, your next job may have you wearing more than one hat in an environment with no SAN, and then all that stuff you had to learn and maintain will pay off.

Comments
There are no comments on this post
Leave a Comment
Only members of SQLServerCentral may leave comments. Register now for your free account or Sign-In if you are already a member.