I have been unable to find any info on monitoring replication with SQL Monitor within this forum and Google searches. It appears the list of alerts is fixed and there is no way to add "custom" alerts, am I correct? I am specifically interested in the sp_replcounters stored procs "replicated transactions" field, which contains the number of transactions in the log awaiting delivery to the distribution database. This info is also available in the DMV sys.dm_os_performance_counters. Would appreciate any information on this topic. Thanks.
Comments
1 comment
Add comment
Please sign in to leave a comment.