September 2010
Intermediate to advanced
1704 pages
111h 8m
English
During our ramp-up on SQL Server 2008, we decided to conduct a benchmark that pitted SQL Server 2005 database mirroring against the exact same configuration with SQL Server 2008 database mirroring. Microsoft had described some performance improvements and other added features that sounded like viable reasons to upgrade to SQL Server 2008. At the heart of our benchmark we would be seeing how much performance improvement was possible with the changes that Microsoft has made to compression of the transaction log records on the principal side, their transmission to the mirror, and the restore to the mirror. Using identical servers, we conducted a fully loaded test with heavy transaction rates—first ...