DTM Data Comparer Performance Report

[ June 2012 revision ]

Server 1: Intel Core 2 Quad CPU 2.4GHz, 6Gb RAM
Server 2: Intel Core 2 Duo CPU 2.2GHz, 2Gb RAM
Client: Intel Core 2 Duo CPU 3.2GHz, 8Gb RAM

Test Description Default mode Differences only Performance mode
Test #1
Client with local SQL Server 2008
2 tables with 5,000,000 rows,
3 integer columns
about 5% differences
83 356.59

rows/sec
83 561.59

rows/sec
114 365,17

rows/sec
Test #2
Client with local SQL Server 2008
2 tables with 5,000,000 rows,
3 integer columns
100% differences
335 694.74

rows/sec
347 995.62

rows/sec
421 194.59

rows/sec
Test #3
Client local SQL Server 2008
Server 2 with SQL Server 2005
1 Gbit LAN
2 tables with about 1,000,000 rows,
3 integer columns
about 5% differences
34 834.85

rows/sec
39 879.82

rows/sec
46 612.44

rows/sec
Test #4
Client local SQL Server 2008
Server 2 with SQL Server 2005
1 Gbit LAN
2 tables with about 1,000,000 rows,
3 integer columns
100% differences
80 166.36

rows/sec
79 726.13

rows/sec
88 051.02

rows/sec

See Also