Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-22 : 10:00:03
|
| Gregory writes "I am receiving messages in my application log that say I have a suspect agent every ten minutes. I have tracked it down to the "Replication Agents Checkup" scheduled task that is automatically setup when you setup replication, but I'm a little confused by what it means. All of my replication is working just fine and has been for months, but I get this message in the event viewer that eventually fills up the log. It isn't and error per say it is an informational entry. Any ideas what is causing this, why, or how to stop it?" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-22 : 12:13:50
|
| When a replication agent is running longer than the amount of time in the Inactivity Threshold, then the agent will be marked as suspect. Because the Replication Agent was busy when SQL Server polled the agent for a response.As you said, it is just an informative message, and is not, by itself, indicative of a problem.Using the SQL Enterprise Manager, with Replication Monitor enabled, you should check the following for more information on the agent.- Right Click the Agent in question, and check for Error Details. If there are not any, then option will be greyed out.- Right Click the Agent in question, and check the agent history.- You can also increase the inactivity threshold, by right clicking the Agents folder, and choosing Refresh Rate and Settings.-Chad |
 |
|
|
kioteh
Starting Member
16 Posts |
Posted - 2002-02-26 : 10:30:30
|
| If this is transactional replication, isn't the agent always going to be busy? Why would it keep putting messages in the event viewer and ultimately fill it up for mere informative messages? |
|
|
|
|
|
|
|
|
Replication Error?!?