Microsoft KB Archive/943247

= Description of support for SQL replication of the profiles database and of the transactions database when you run Commerce Server 2007 Service Pack 1 together with SQL Server 2005 Service Pack 2 =

Article ID: 943247

Article Last Modified on 11/30/2007

-

APPLIES TO


 * Microsoft Commerce Server 2007 Enterprise Edition
 * Microsoft Commerce Server 2007 Developer Edition
 * Microsoft Commerce Server 2007 Standard Edition
 * Microsoft Commerce Server 2007 Service Pack 1

-



INTRODUCTION
Microsoft supports SQL replication of the profiles database and of the transactions database in one configuration when you run Microsoft Commerce Server 2007 Service Pack 1 together with Microsoft SQL Server 2005 Service Pack 2.



MORE INFORMATION
Microsoft has tested peer-to-peer transactional replication in a multiple-instance cluster. The multiple-instance cluster consisted of two pods. Each pod contained the following:
 * Twelve Web servers.
 * Two database servers. The first database server contained the profiles database and the transactions database. The second database server contained the other databases.
 * Six load clients.
 * A storage area network (SAN).

By using this test architecture, replication was reliable at the test rate of 22 transactions per second and 130 profiles per second per pod, concurrently. The performance effect of both the CPU and of the disk I/O was less than five percent. High network latency has a significant effect on the commit time.

Additional query words: SP1 SP2

Keywords: kbhowto kbinfo kbpubtypekc KB943247

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.