Hello My followers  today i will took in very important subject for any DBA How we can monitor our Replications !! for any replication i have publication and subscription , How i can now is it working or it is active or down or what is the status of it now , based on that i created one DMV build with technique of Dynamic Query and using SQL Server cursor but before you go for Monitoring (advanced level) you should know some points at the beginning :

 

 

 

 

Replication in SQL Server Part 1

• What is SQL Replication?
• Types of SQL Replication
• Replication Overview

Replication in SQL Server Part 2

• How to create Transaction Replication

Replication in SQL Server Part 3

• How to Add New Publisher Server to the Distributor Server

Replication in SQL Server Part 4

• Disable Publishing and Distribution Servers

Now after we explained the main highlights for the replication lets see How we can monitor the status of the publication and subscription? and How we can receive email if any one of them is InActive :

• First i return all databases used in replication

[sql]

SELECT
 MSA.publisher_db AS 'Database Name'
FROM
 distribution.DBO.MSarticles AS MSA
OPEN db_cursor
[/sql]

Continue reading “SQL Server DMV Replication Monitoring Part 1” →