I received an unexpected but certainly not unwelcome email last night letting me know that I've been selected to present a spotlight session at the 2010 PASS Summit! I'll be talking transactional replication, and while I could spend all day on the subject I'll be sure to make the most out of the 90 minutes I get. No word on scheduling specifics, but I can only hope that I'm on day 1 or 2 this year. Last year I was put in the final session for day 3 and I'm pretty sure everyone was burned out by then (I know I was).
Speaking of the Summit, if you plan on going and haven't registered yet don't wait! Register before June 30 to get the discounted rate of $1,395 - that's a 30% discount ($600) off the full price.
Here's the details on my spotlight session:
Transactional Replication: Beyond The Basics
Description: 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.
Goals:
- Learn advanced replication monitoring techniques including: Replication monitor, replication alerts, and tracer tokens.
- Learn how to tune replication performance using agent profile parameters.
- Learn how to troubleshoot and fix common replication errors.
