Can someone provide a detailed explaination of
1.how Many Agents are at work on a Transactional Replication
2.how they Work?
3.What is VLF and how does it relate? Thank you.
View Complete Post
We have a customer with three publications, one distributor/publisher and on subscriber using merge replication.
looking at the history of the job replication agents checkup, every entry shows a message of:
Executed as user: NT AUTHORITY\SYSTEM. The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections
to the Subscriber, Publisher, and Distributor are still active. [SQLSTATE 01000] (Message 20554). The step succeeded.
Throughout the day this error still appears as this job runs every 10 minutes but replication works fine. The issue is at some point throughout the night the replication stops with that same message. Sometimes it stops at 6:00:00am, sometimes at 6:40:00am,
others at 6:50:00am. All we have to do to fix it is go into the replication monitor and stop synchronizing and then start synchronizing and replication will run all day until it stops next morning - again.
What is causing that error message? I have checked the other logs and there is nothing running at those times. in addition, no one has logged into the server that early (they don't start arriving until 7:15 or later).
What can i do to correct the issue so the message stops happening.
I am trying to generate a scipt to rename the replication distribution agent jobs using the MSDistribution_agents table. I have found a way to rename the snapshot jobs on the Publisher based on the information stored in the job_id field in
the MSsnapshot_agents table and I was hoping to do the same for the distribution jobs using the job_id and the information stored in the MSDistribution_agents table.
The problem is that the distribution agents are running on a different database on a different box and there is no way that I can associated the job_id in the MSDistribution table with any of the job_ids in the msdb.sysjobs on the remote server.
Can anyone tell me if the job_id stored in the MSdistribution_agents table corresponds to any of the objects on the remote servers? I need to do this on more than 6 servers so it is very tedious trying to manually rename the jobs everytime I have to fix/setup
Thanks in advance for looking at this
We use the new Asynchronous Agents Library in Visual C++ 2010 to solve the classic Dining Philosophers concurrency problem.
MSDN Magazine June 2009
In artificial intelligence, an agent is a logical entity that has some level of autonomy within its environment or host. A mobile agent has the added capability that it can move between hosts. In this article Matt Neely brings mobile agents from the halls of academia to a dev shop near you.
MSDN Magazine February 2006
MSDN Magazine September 2003
Last week Android updated their software (changed the display from 480px to 800px) so all the mobile tweaks we made for our apps are no longer work on Droid Phones.
I would need to identify the User Agent(e.g. Android) and switch style sheets depending. (We don't want to redirect to another page, just switch style sheets).
Anybody know any lightweight solution ?
Thanks in Advance.
(we were using 480px pixels to identify if the user was coming from iPhone or Android and switched stylesheets accordingly. If I changed it to 800px some desktop monitors and the iPad would see the mobile version and not the desktop version. Not good.)