Post reply

distributor agents job in replication

  • March 24, 2009 at 1:33 pm

    #207718

    Hi All,

    Now a days iam noticing that at some point of time i could see 2 distributor agent jobs are running parallely to a single subscriber at the same time.

    The schedule of the distributor agents job is 15 mins.

    Is it the normal behaviour.

    Could any one suggest what exactly the issue might be.

    The replication is transactional replication

    Regards,

    Sandhya

  • March 25, 2009 at 6:46 am

    #965944

    What I can think of is, you might be having two agents running one to run at scheduled time (recurring) and another in –Continuous mode.

    Investigate by looking into MSdistribution_agents and MSdistribution_history table on distributor.

  • March 25, 2009 at 6:49 am

    #965947

    What I can think of is, you might be having two agents running one to run at scheduled time (recurring) and another in –Continuous mode.

    Investigate by looking into MSdistribution_agents and MSdistribution_history table on distributor.

  • March 25, 2009 at 1:02 pm

    #966217

    You can have one agent per publication, so there is nothing new about this.

    If you have multiple publications going into one subscriber you will see multiple distributor agents.

    There could be misconfiguration issues also but you will have to check that out on the SQL Agent Jobs


    * Noel

  • March 25, 2009 at 7:21 pm

    #966392

    Hi All,

    Thanks for the reply.

    We have single publisher to single subscriber replication.

    I checked and found that the disributor agent job is scheduled to run once in every 15 mins and we have only one distrinutor agent job.

    I found this issue last week.

    But it is running fine.

    Any ideas for the issue to occur occasionally.

    By the way I have one more query.

    Is there any way to find the no rows that is being transferred from publisher to subscriber.

    Is this information is logged in any table of the distribution database.

    Thanks,

    Sandhya

  • March 27, 2009 at 3:49 am

    #967265

    Look into

    MSrepl_transactions

    MSrepl_commands

    looking info sp_browsereplcmds

  • March 30, 2009 at 12:46 pm

    #968577

    Just one clarification. publisher is a SERVER, publication is associated with a database.

    - You can have MULTIPLE publications with ONE publisher and ONE database.

    - In the same way you can have MULTIPLE Subscriptions coming from ONE Publication and ONE database...


    * Noel

Viewing 7 posts - 1 through 6 (of 6 total)

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