syscomments

RocketScientist's Miscellaneous Ramblings
posts - 76, comments - 354, trackbacks - 3

June 2007 Blog Posts

Database Mirroring

One of the things I'm investigating is DR, actually not really disaster recovery, more of a "service availability" problem.  I'm not trying to address the DR situation yet, just the "OMG SERVER CRASH" problem. So I started doing research on clustering vs mirroring, since I hadn't done it before.  If you're researching mirroring, start here: http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx That's a technet whitepaper on mirroring.  After you're done with that, go here: http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx Performance implications of mirroring, along with best practices stuff.  The interesting part of the second paper is the performance implications of  the encryption options (negligible impact, should always be turned on).  I found...

posted @ Wednesday, June 27, 2007 11:19 AM | Feedback (0) |

Powered by:
Powered By Subtext Powered By ASP.NET