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

Inactivity Threshold of transactional replication Expand / Collapse
Author
Message
Posted Tuesday, January 26, 2010 11:25 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, August 23, 2014 12:50 PM
Points: 310, Visits: 655
I am using sql server 2k8 for transactional replication.

I get following error frequently:

The agent is suspect. No response for the past 10 minutes

I increased polling interval but no gain. I want to increase inactivity threshold now.
How to change the Inactivity Threshold of transactional replication?

-Lk
Post #854175
Posted Wednesday, January 27, 2010 12:14 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Saturday, August 9, 2014 11:36 PM
Points: 676, Visits: 245
Hi,

If the Distribution Agent is where you get this message, and the job schedule is set to continuous try to change the schedule to every xx min. You can choose the value for xx according to your latency requirements.

I hope this helps.
Post #854197
Posted Wednesday, January 27, 2010 12:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, August 23, 2014 12:50 PM
Points: 310, Visits: 655
But MSzI,

My question is something else.

How to change the Inactivity Threshold for any agent in sql2k5?

-Lk
Post #854208
Posted Wednesday, January 27, 2010 2:10 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Saturday, August 9, 2014 11:36 PM
Points: 676, Visits: 245
right!

Check this procedure in BOL: sp_changedistributor_property

MSzI.
Post #854233
Posted Wednesday, January 27, 2010 6:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, August 23, 2014 12:50 PM
Points: 310, Visits: 655
Do you mean that inactivity_threshold is set only for distribution agent. Is this not set for log reader agent.

How to changed the value of inactivity_threshold using GUI?

-lk
Post #854319
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse