Lesson 3

Monitoring Transactional Replication

Learning Objectives

By the end of this lesson, you will be able to:

  • Set up the replication monitor
  • Monitor and troubleshoot transactional replication
  • Monitor and troubleshoot peer-to-peer transactional replication

This lesson will show us how to monitor and manage transactional replication. We will also look at how to troubleshoot issues in transactional replication.

Introduction

In the previous lesson, we learned that transactional replication can be used to maintain one or more secondary copies of a database. The secondary database can be used for HA or DR purposes or to offload the reads from the primary database.

In this lesson, we will learn how to monitor transactional replication using ...

Get Professional SQL Server High Availability and Disaster Recovery now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.