Queries to build START and STOP commands for PUSH Distribution Agents

Chris Skorlinski, Microsoft SQL Server Escalation Services I had need other day to STOP and START all Distribution Push Agent.  Using the syssubscriptions and syspublications I can easily build list of SQL commands to either stop or start all the Distribution Push Agents.  With output to text, I can copy and execute from SQL Agent…


Follow the Data in Transactional Replication

Follow the Data in Transactional Replication Chris SkorlinskiMicrosoft SQL Server Escalation Services Abstract Many technology solutions use a STORE and FORWARD model to move data though out the business. It begins when source data change is detected, collected, and STORED in a cache. This cache data, often on a schedule, is processed and FORWARD to…


Unexplained Latency in the Distribution Agent using Named Pipe

Unexplained Latency in the Distribution Agent using Named Pipe Chris Skorlinski Microsoft SQL Server Escalation Services. Just wanted to give a heads up about a SQL Replication Distribution Agent Latency problem we observed today.  The Distribution Agent to 1 subscriber was only delivering about 500 cmds/sec while other subscribers were getting 4000 cmds/sec.  We noticed…

0

KB article 312292 How to enable replication agents for logging to output files in SQL Server

KB article 312292 How to enable replication agents for logging to output files in SQL Server by Chris SkorlinskiMicrosoft SQL Server Escalation Services While troubleshooting SQL Server Replication we often want to capture detail step-by-step execution of Replication Agent.  One technique is to configure the Agent to log its execution to a Text file.  This…