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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
