O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

What’s New in Database Mirroring

Not much new for SQL Server 2012 database mirroring. As previously mentioned, all new database failover and distributed workload attention has gone to AlwaysOn Availability Groups. However, in SQL Server 2008 R2, the essential improvements of high performance were provided that have now all been absorbed into the AlwaysOn components. These performance improvements were brought about by Microsoft’s efforts to isolate and resolve the bottleneck that was centered on the bulky transmission of full-size log records from one SQL Server to another. Improvements in the data compression used on the log records sent from one server to the other solved most of this bottleneck. In addition, as records are being written to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required