Skip to Main Content
Professional SQL Server High Availability and Disaster Recovery
book

Professional SQL Server High Availability and Disaster Recovery

by Ahmad Osama
January 2019
Intermediate to advanced content levelIntermediate to advanced
564 pages
9h 2m
English
Packt Publishing
Content preview from Professional SQL Server High Availability and Disaster Recovery

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Professional SQL Server 2012 Internals and Troubleshooting

Professional SQL Server 2012 Internals and Troubleshooting

Christian Bolton, James Rowland-Jones, Glenn Berry, Justin Langford, Gavin Payne, Amit Banerjee

Publisher Resources

ISBN: 9781789802597Supplemental Content