Mirroring Aignt Easy
Chris Shaw has a new nickname. I here by dub the “Meme”. He has a new quiz out. Meme tagged Brent Ozar(WWW, Twit) who tagged Thomas LaRock(WWW, Twit) and Tim Ford(WWW, Twit) as well as myself. Boy did he open a can of worms. Meme called out Brent who has awoken the blogtacular members of the now defunt Bacon bits and bytes. If you don’t know, you don’t need to know.
First Question…
1. Do you feel that you have a reliable SAN Solution? If so what is the secret?
Yes, I have an awesome SAN team that transparently produces 1’s and 0’s faster that a hound dog could eat a pork chop. Faster than a catfish bites stink bait. They are hillbilly as hell good southern folk.
On top of that, I run SQLIO as soon as a new SAN is up and I know what throughput should be. I demand 1ms latency(AVG Disk Sec\Transfer). I am ready to pounce on a SAN admin as soon as I can prove that my slow clunky queries are being held back by the SAN. They know this too. However, I have yet to run into a problem where I could rightly demand my pound of succulent SAN admin flesh. Not even on RAID5 and *gasp* RAID6.
However, the most important thing that my SAN admin taught me is this. It is not the banjo that makes you slap yo knee, it is the banjo player. Same goes for your SAN. Yall come back now, ya hear.
2. I was recently asked to describe SQL Server Database Mirroring. The client that I was answering the question for was trying to use database mirroring for a reporting server. When I explained to him the issues around this he asked me to describe in laymen’s term what database mirroring was.
Describing Mirroring is easy.
Well, maybe I shouldn’t…
You never know when the words you utter on the innerwebz will come back to haunt you.
Aww hell…
Here comes a CLM of epic proportions all over the tubes.
Lets do this!
Database Mirroring is just like pimpin’. Yah, you heard me, playa and playettes. Mirroring is all about transactions just like the pimp game. The primary is the customer and the mirror is the pimp. Mirroring(The Prostitech) performs her service on the primary’s log and delivers the transactions to the mirror(AKA Me AKA Dig Daddy J). Faster the better. I will leave it at that but you best recognize, yo. “Mirroring Aign’t Easy” and you can quote me on that.
I am going to pimp check SQL Server Sleuth(WWW, Twit), Jonathan Kehayias(WWW, Twit), Paul Randal (WWW, twit)
This content is published under the Attribution-Share Alike 3.0 Unported license.
Comments
-
David Stein
-
Jason Massie
My RSS
-
My LifeStream
My Presence
