DX Unified Infrastructure Management

  Hi,

Is there any UIM probe available for monitoring Database Replication. Currently we are monitoring with DB query execution method, by connecting PR and DR Servers through UIM probe and executing Query to check last replication status. Because of this execution method UIM DB is getting loaded with lot of transaction log data.

Can anyone please suggest best way to do DB replication monitoring with UIM.

Hi,

it might be helpful if you can provide more details about the type and version of the database you are trying to monitor.

Does the sqlserver write this out to a log you can read or a windows event log so that you could use another probe

such as logmon or ntevl?

if you provide more details we might be able to provide some alternatives.

Also can you post the query you are using as I am not sure I understand why doing a custom check point would

increase your transaction log size on your database.

Hi,

We have a slightly different need but in our case we simply monitor for replication failures. Based on the information provided by our DBA team we are looking at the MS SQL Server errorlog file with the logmon probe. When there are replication failures we match them with the text search "*Replication*failed*" and generate an alarm. They seem happy with it as they were able to find and solve replication issues related to critical web sites.

We use MySQL Percona running on Redhat Linux and have this SQL query running (in Logmon) on our Primary Server which checks if replication has fallen behind:

mysql --host=INSERT_HA_HOSTNAME --user=root -e "show slave status\G;"|grep Seconds_Behind_Master|cut -d ':' -f2| sed -e 's/^[[:space:]]*//'

This detects if replication is an hour or more behind.

Hope it helps!

You should be able to monitor your replication via database probes like sqlserver and Oracle etc with default monitors. Or you can create a customer monitoring with your requirement in these probes. Or another option would be to utilize jdbc_response probe where you can use your current query.