search

trimble-oss / dba-dash

DBA Dash - SQL Server Monitoring Tool
MIT License
267 stars 62 forks source link

Add Features Monitoring Replication #1007

Open aachaemenes opened 2 months ago

aachaemenes commented 2 months ago

Please add a feature to monitor transactional replications.

DavidWiseman commented 2 months ago

Hi,

Thanks for the suggestion. This isn't a feature I currently use and it's not something I have any experience with outside of a lab environment. I'm unlikely to add any replication monitoring features unless it gets adopted somewhere within Trimble.

Depending on what you want to track, I think there are some replication metrics available in sys.dm_os_performance_counters. You can add any counters from here into DBA Dash by editing an XML file to include it. The process is documented here. The link also explains how to add custom metrics from a SQL query - providing flexibility to add any custom metric.

Another option is a custom collection and custom report which provides more flexibility on how to store and process the data. I use this feature now to prototype new collections. e.g. Server Services & Table Size.

If you build something with this, consider scripting out the custom collection and associated report to share with other DBA Dash users. There would be a bit more work to convert it to a system collection/report but this might also be an option. DBA Dash is open source - pull requests would be considered to add replication monitoring.

Hope this helps,

David