Database Mirroring Improvements
As you might expect, SQL Server 2008 also makes improvements to database mirroring.
There aren??™t any fundamental changes: mirroring still works basically the same, and the
different modes of mirroring available remain the same. Rather, the changes lean more
toward fine-tuning than redesign.
Automatic Page Repair
The one exception to what I just said about fine-tuning is the new feature of automatic
page repair. If the principal and mirror are in a synchronized state, page-level errors
occurring at either node are repaired automatically. If a mirror detects a corrupt page, it
will request a replacement from the principal. If the principal detects a corrupted page,
it will request a replacement from the mirror. It??™s like having an off-site mechanic continually
fixing your car.
APPENDIX n SQL SERVER 2008 CONSIDERATIONS 326
Database Mirroring Tuning
SQL Server 2008 also includes some much-needed improvements to the speed of database
mirroring operations. These improvements include
??? Log compression: Data changes sent over the network from the principal to the
mirror are now compressed.
Pages:
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611