SQLBits 2010

Troubleshooting Transactional Replication in the Wild

Transaction Replication is a widely used feature in SQL Server though its internals are sparsely understood. In this session we will look under the hood and gain indepth understanding about Transactional Replication architecture and its corresponding components like logreader and distribution agents, Reader/Writer threads, etc. We will learn methods of identifying and monitoring replication latency and methods of troubleshooting and eliminating bottlenecks to improve Replication Performance.

Transaction Replication is a widely used feature in SQL Server though its internals are sparsely understood.

In this session we will look under the hood and gain indepth understanding about Transactional Replication architecture and its corresponding components like logreader and distribution agents, Reader/Writer threads, etc. We will learn methods of identifying and monitoring replication latency and methods of troubleshooting and eliminating bottlenecks to improve Replication Performance.