Is there a way to see the transaction rate (trans/sec) per database?
A related question - does DPA have a way of showing transaction log activity?
We only collect this data per instance currently. I think this would make a good feature request though.
Can you define what you mean by transaction log activity? Do you mean growth, truncation, log writer waits, other?
Number of writes. Looking to analyze a specific case where the transaction log backups have increased in size.