Storage

Jimmy May explains Partition Alignment (#sqlpass)

#SQLPass, Storage
5 Comments
Before attending this session, I’ve always gone to KB article 929491 article on partition alignment.  I thought I kinda sorta understood what was going on, but Jimmy’s presentation drew on the best graphical illustrations to show it.  Not to mention his audio stylings like, “Holy correlated wait stats!” Get your binoculars out Partition alignment is…
Read More

IBM SVC Entry Edition pricing out

Storage
0
IBM just unveiled a smaller-scale edition of their storage virtualization solution called IBM System Storage SVC Entry Edition.  From the interwebs comes a press release which includes this juicy quote: “The idea is to make it more affordable for smaller companies – the entry edition is priced per disk drive with a starting configuration costing…
Read More

SAN Tips for First-Time Users

Storage
0
If you’re thinking about buying your first storage area network, do yourself a favor and go to the Aston Martin dealership first.  Smell the leather – that is, if they’ll let you sit in one – and play with the switchgear to feel how nice and solid it feels.  Pretty nice, huh? Or maybe that’s…
Read More
Param.txt

SQLIO Tutorial: How to Test Disk Performance

SQL Server, Storage
Storage is a black box, right?  The SAN admins ask how much storage space you need, you tell them, and then they give it to you.  They don’t tell you how fast (or slow) it is, they don’t know whether it meets your needs, and they probably don’t know where the bottlenecks are. It’s time…
Read More

Why DBAs should care about storage virtualization

Storage
2 Comments
Vendor hype aside, storage virtualization is really expensive technology that few shops really use.  Don’t get me wrong, I love the technology, but seriously, it’s expensive.  And that’s just the hardware/software – try hiring somebody with storage virtualization experience – hoo, boy.  But something is coming that’s changing the game, redefining what storage virtualization means.…
Read More

Steel Cage Blogmatch: How to Configure a SAN

SQL Server, Storage
13 Comments
Jason Massie and Brent Ozar work with SQL Server for a living and write blogs for fun, but that’s where the similarities end.  Jason’s a fan of shared storage SANs: putting SQL Server data and logs on the same set of physical hard drives.  Brent’s a cheerleader for dedicated configurations where the arrays are separated…
Read More

Storage virtualization for SQL Server: friend or foe?

Storage
0
Storage virtualization is a really slick SAN technology that does for SANs what VMware did for servers: it abstracts away the underlying hardware to make management easier.  Multiple SANs can be swapped around back and forth behind the scenes without affecting any servers that store data on those SANs. It’s nowhere near common yet –…
Read More

Dell EMC AX150i review

Storage
15 Comments
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…
Read More

Ugly month of outages

Hardware, Storage, Virtualization
9 Comments
The past month has been a real challenge, filled with 70-80 hour weeks and clawing back from one disaster after another. In late June, IBM recommended that we upgrade the firmware on our DS4800 SAN controllers to fix some problems. We obliged, and two days later, our Exchange cluster rebooted without warning. We’d been having…
Read More
Menu