January 26, 2010 at 11:25 pm
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
January 27, 2010 at 12:14 am
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.
January 27, 2010 at 12:40 am
But MSzI,
My question is something else.
How to change the Inactivity Threshold for any agent in sql2k5?
-Lk
January 27, 2010 at 2:10 am
right!
Check this procedure in BOL: sp_changedistributor_property
MSzI.
January 27, 2010 at 6:22 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply