Posts Tagged ‘san’

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!”
Partition alignment is one of those hidden performance [...]

At the SSWUG 2008 Virtual Conference on Wednesday, I’m talking about how to find your storage bottlenecks with SQLIO.  Instead of posting my code here on the blog, it’s over on the new SQLServerPedia wiki.  That way, instead of writing comments on here about how bad my code is, you guys can correct it yourselves.  [...]

You’ve heard me talk about my SSWUG video conference sessions, but you’re not sure whether it’ll work, or whether it’s worth the money?  Well, Chris Shaw and the good folks at SSWUG are giving away free previews to show you how good it looks.  You can watch the first ten minute of my SQLIO session [...]

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 not [...]

The SAN 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.
And it’s not their [...]

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.
When [...]

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 [...]

A reader wrote in and asked:
We’re running SQL Server with blades and a NetApp SAN. We have a few hundred databases from 100mb to 200gb.  All data, logs, tempdb, etc. are located in the same 30-disk pool.
Apparently this was setup using NetApp’s guidelines. NetApp recommendations are to put everything in one aggregate, or a couple [...]

Lemme play psychic for a minute.  Put your hands on the monitor, and I’ll tell your future.
It’s coming to me…wait…I see.  Your boss is cutting your budgets.  You know those conferences you wanted to attend?  Those ones that were going to require expensive airfare and hotels?  It ain’t happening.  Sure, the boss might not have [...]