Transactional Replication: Beyond The Basics
Transactional replication can support synchronizing from as few as a hundred to as many as hundreds of millions or more of changes a day across multiple servers. However, replication is more than clicking your way through wizards; Monitoring and tuning are required to achieve optimal performance and the number of processes involved increase the likelihood that problems can (and usually will) occur. This session is for DBA already familiar with the basics of transactional replication and looking to go beyond the setup wizards to gain a deeper understanding of the technology. We'll cover monitoring techniques, calibrating performance, and troubleshooting common replication problems plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.
Channel Intelligence, Inc.
Kendal began working with SQL Server 7.0 as a developer in 1999. He has spent the last 9 years as a production DBA working on systems that process hundreds of millions of transactions per day. He is currently Senior DBA at Channel Intelligence in Celebration, FL where he is responsible for the management, monitoring, and performance of 40+ SQL Servers. Kendal stays active in the SQL Community by speaking at events such as SQL Saturday, .NET Code Camp, and OPASS (Orlando PASS chapter). Kendal is known as @SQLDBA on Twitter and is a contributor to the forums on SQLServerCentral.com. Kendal also maintains a technical blog on SQL Server topics at http://kendalvandyke.blogspot.com.
Register Now for PASS Summit 2010!