Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

distributor agents job in replication Expand / Collapse
Author
Message
Posted Tuesday, March 24, 2009 1:33 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Wednesday, March 25, 2009 6:46 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 6:04 AM
Points: 305, Visits: 381
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
Posted Wednesday, March 25, 2009 6:49 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 6:04 AM
Points: 305, Visits: 381
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 #683256
Posted Wednesday, March 25, 2009 1:02 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:34 AM
Points: 6,259, Visits: 2,031
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
Posted Wednesday, March 25, 2009 7:21 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Friday, March 27, 2009 3:49 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 6:04 AM
Points: 305, Visits: 381
Look into
MSrepl_transactions
MSrepl_commands

looking info sp_browsereplcmds



Post #684849
Posted Monday, March 30, 2009 12:46 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:34 AM
Points: 6,259, Visits: 2,031
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 »

Add to briefcase

Permissions Expand / Collapse