Kenneth.Fisher (1/11/2012)
I appreciate ya'lls help with this. RAID has always been a difficult subject for me but I think I'm finally getting it down.Just as an aside, we have the interesting problem of not always knowing where are drives are comming from. In other words, the D drive and the E drive may actually both be on the same RAID array, but no one told us, its just the way it was allocated out.
Very common in a SAN scenario. You usually have to work closely with the SAN team to get things setup physically the way you need them, but you'll almost always get pushback on this because it's 'wasteful' from their perspective unless you have a definate need and can prove I/O is your stall. It's up to you if it's worth the small war it can turn into, depending on your team. It might even be a friendly war, but you usually end up in one either way. SAN space is expensive a lot of places and it's their job to make sure it's used optimally from their side, too.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA