On the Microsoft side, Kevin Holman does a great job feeding useful content about Operations Manager to the masses and is probably one of the key people whose content you should follow. In a recent post, he talks about how to monitor databases other than Microsoft’s using OpsMgr and goes through an example using Postgre SQL.
From the post:
OpsMgr has the capability to run a synthetic transaction, to query a remote database from a watcher node. This can be used to simulate an application query to a back end database, and we have built in monitoring to set thresholds for:
- Connection time
- Query time
- Fetch Time
We will also auto-create three performance rules – so that you can collect these as performance data for short term investigation, or long term trending.