Post reply

update table scenario

  • April 22, 2010 at 8:16 am

    #221748

    hi..

    I have server A and server B are in replication.

    server A is publisher and Server B is subscriber..

    We are pulling data from A to B. so pull subscription is there in server B.

    It is transactional replication.

    Now the question is table 123 is keep updating in server B because constantly data coming from server A.

    Now my concern is when i use select query to fetch records in server B, sometimes it takes 15 sec,20 sec,1 min and sometimes 5 mins..

    can u pls let me know why this happen? Is there due to replication?

    thanks

  • April 28, 2010 at 3:43 am

    #1158733

    Pls check index fragmentation

  • April 28, 2010 at 9:38 am

    #1159067

    Check for blocking as well. That might shed some light.

    -Roy

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply