distributor agents job in replication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » distributor agents job in replication

distributor agents job in replication

Rate Topic

Display Mode

Topic Options

Author

Message

sandhyarao49

Posted Tuesday, March 24, 2009 1:33 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650

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

Post #682767

dkhattar

Posted Wednesday, March 25, 2009 6:46 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 5:58 AM
Points: 304, Visits: 376

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.

Post #683252

dkhattar

Posted Wednesday, March 25, 2009 6:49 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 5:58 AM
Points: 304, Visits: 376

Post #683256

noeld

Posted Wednesday, March 25, 2009 1:02 PM

SSCertifiable

Group: General Forum Members
Last Login: Thursday, June 06, 2013 9:12 AM
Points: 6,260, Visits: 1,980

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

Post #683592

sandhyarao49

Posted Wednesday, March 25, 2009 7:21 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650

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

Post #683799

dkhattar

Posted Friday, March 27, 2009 3:49 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 5:58 AM
Points: 304, Visits: 376

Look into
MSrepl_transactions
MSrepl_commands

looking info sp_browsereplcmds

Post #684849

noeld

Posted Monday, March 30, 2009 12:46 PM

SSCertifiable

Group: General Forum Members
Last Login: Thursday, June 06, 2013 9:12 AM
Points: 6,260, Visits: 1,980

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

Post #686394

« Prev Topic | Next Topic »

Permissions