Chirag Roy
sqlking.wordpress.com
Chirag is a Microsoft Certified Master in SQL Server 2008 and works as Senior SQL Server DBA at UBS. He specializes in delivering and maintaining mission and business critical SQL Server solutions.
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.