SQL Server Performance

Problem during merge replication

Discussion in 'SQL Server 2005 Replication' started by acergrmt, Aug 30, 2006.

  1. acergrmt New Member

    Hi. I have set a replication for 2 minutes for OLTP scanario. After that time I've a huge data to replicated that takes some seconds. Now problem is that at that time online users see different data at different time during merging process. My question is that is tehre any way that we could merge the data as a transaction so that users could see the consistant data or any other solution. Thanks.
  2. dineshasanka Moderator

    set the synchronization schedule to Run countinuously


  3. acergrmt New Member

    For sure its run continously but my problem is different. I'm running a small application in aspx thats show me results. I have production database (for insertion/updation and deletion) that is replicated in LIVE database (used only for selection). During repication when I fetch results from LIVE it gives me different number of records thats generated during replication that starts after every 2 minute. Sample execution is
    No Of records in LIVE = 16830
    No Of records in LIVE = 17288
    No Of records in LIVE = 17674
    No Of records in LIVE = 17888
    No Of records in LIVE = 18483
    No Of records in PRODUCTION = 19713

    You can clearly see here that users see different no of records from LIVE database. Now my question is that is there any way that this replication will be done as a transaction base not at row level so every time result should be consistent. Thanks for your reply.

Share This Page