Is there a place that will show more verbose logs on what exactly is being replicated in a transactional replication publisher and subscriber setup?
Example, I have a SQL on a Azure VM replicating to an Azure SQL database. Where the Azure VM running SQL is the publisher and the Azure SQL database is the subscriber.
We added a ton of records in on the weekend and it mentioned in the replication monitor Log Reader Agent logs, that "Approximately 38000000 log records have been scanned of which were marked for replication. Viewing status of the replication just says "Delivering replicated transactions" and I see the database slowly growing in Azure SQL. That is all the logs are showing me and I am seeing if there is more?
I am wondering if there is a location or query to see what it is replicating exactly at this point and what exactly it is doing? I don't see any location other than replication monitor or I am just missing as to where it would be for what it's doing if I wanted to see.
Any help is appreciated