I have a transactional publication running on Server a with Server b acting as the distributor. I'm trying to determine the efficiency/cost of row filtering that I have in place. I'm hoping that there is a way that I can view the # of changes made per table in n hours, but the only monitoring that I can find right now is the aggregate of all transactions since the agent started.
Is there a better way?
Thanks in advance.
Is there a better way?
Thanks in advance.