MSDN Case Study on Geo-Replication Performance Gains with Microsoft SQL Server 2008 Running on Windows Server 2008

Geo-Replication Performance Gains with Microsoft SQL Server 2008 Running on Windows Server 2008

3,000 mile replication

Test

SQL 2005/Win 2003

SQL 2008/Win 2008

Push Replication

1-GB

226.12 (minutes)

110.42 (minutes)

Pull Replication

1-GB

174.87 (minutes)

12.5 (minutes)

Linked Server

10-MB

107.6 (minutes)

113.6 (minutes)

Push Replication

112-MB

247.07 (minutes)

59.13 (minutes)

Pull Replication Records

112-MB

223.18 (minutes)

1.95 (minutes)

Snapshot Replication

11.3-GB

Not tested

22.75 (minutes)

Geo-Replication Performance Gains with Microsoft SQL Server 2008 Running on Windows Server 2008 3,000 mile replication Test SQL 2005/Win 2003 SQL 2008/Win 2008 Push Replication 1-GB 226.12 (minutes) 110.42 (minutes) Pull Replication 1-GB 174.87 (minutes) … http://sqlmashup.posterous.com/msdn-case-study-on-geo-replication-performanc

Advertisements

About Robert Matthew Cook

Hello, my name is Robert Matthew Cook. This blog is autoposted to from my main blog at www.sqlmashup.com. For more profile information or to leave a comment, please visit me there.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s