Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

SQL Quiz 5: SANs Mirroring


My turn to answer Chris Shaw’s questions “Do I feel I have a reliable SAN solution?” and “Describe Database Mirroring for the layman?” Thanks Tim. I’ve a feeling you’re going to be disappointed.

SAN:
Hell, how should I know? Want to talk about a black box? Our SAN, as far as I’m aware, is run by a group of crack-shot ninja assassins and powered by pureed virgin unicorn. This strange mix of esoteric skill, magic and blood is evidently able to provide us with just about perfect up time. Once, one of the ninja’s must have gone rogue (speculation) and had to be put down by his brother ninjas because we had a drive disappear on the cluster server. It took us a couple of hours, but it recovered as if it was never gone.

Honestly, I just don’t know. We’ve done performance tests and we’re getting more than adequate I/O. I know that we don’t have all kinds of specialized luns catering to the tempdb or log files. Instead we have what appear to be drives that we can use for storing data. It just works. Our team has tried communicating with the ninjas, uh, I mean SAN administrators, but they kind of just nod their heads, ask us how much space we need, and suppy us with another drive. 

Mirroring:
I’m not sure how I’d describe this to the layman. I’d say it’s like a stand-by pump, but automatic. If the main pump goes down, the valves automatically switch and the stand-by pump comes online. Our business people have learned what fail-over clusters work like. I could tell them that it’s like a fail-over cluster, but without the shared drives, which makes it safer in a lot of ways. However, beyond reading about mirroring, I have yet to implement it, so it’s all theory for me.

So to sum up, the answer to both questions is, I don’t know. Pretty pathetic, but honest.

Let’s tag… Tim Mitchell & T-Jay Belt. Those guys should have more going on than I do.

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.