I have transactional replication with many publishers(50+) and one central subscriber(data collecting).
Is there some way(feature of SQL server, 3th party tool) how to monitor all publications from one point ideally from central subscriber?(something like monitoring server with multiple publications with Replication monitor)

1 Answer
1

Yes there is. The way I do it is I have a SQL Agent job post tracer tokens at a regular interval to the publishers and then monitor their progress from the distributor (where their history is stored). I created a view in the distribution database that helps with that.