Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


Keywords: KB943247, kbhowto, kbinfo, kbpubtypekc

↑ Back to the top

Article Info
Article ID : 943247
Revision : 2
Created on : 11/30/2007
Published on : 11/30/2007
Exists online : False
Views : 410