SQL Server Administration and Maintenance

SQH14 Designing and Managing a SQL Server Replication Topology

11/21/2013

1:30pm - 2:45pm

Level: Intermediate

Chad Churchwell

Premier Field Engineer

Microsoft

This session is focused on design and architectural decisions when choosing replication as a technology to use within your organization. We will cover all the moving pieces involved with replication, the internal architecture of how replication works, as well as describing the agents in detail. One will also learn what replication is intended to do as well as what it is not a good fit for. I will cover the new SQL 2012 support enhancements as well as combining with AlwaysOn Availability groups to protect your replication environment to ensure minimal downtime. I will also cover monitoring and alerting on replication errors and latency to ensure accurate data.

You will learn:

  • How replication works behind the scenes and architecturally to better prepare yourself with knowledge to manage a replicated environment.
  • How to be proactive and use best practices for monitoring and alerting of replication issues when they arise as well as how to resolve common replication errors.
  • How replication can be used with a high availability technology to ensure protection of your mission critical systems.