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
MSA.publisher_db AS 'Database Name'
distribution.DBO.MSarticles AS MSA
Continue reading “SQL Server DMV Replication Monitoring Part 1”