I am working with a customer who has several SQL Server and Oracle DBMS server instances. My customer would like to setup up performance data collection, monitoring and alerting for all of their databases. My strength is in SQL Server and I know lots of products/tools for doing this there, but there seems to be very few options for one tool or product that can do both Oracle and SQL Server at the same time.
One option that has been suggested is Oracle Performance Manager, which apparently can also monitor SQL Server. I have been trying to read up on it, but there's a lot of doc out there and I am not very familiar with it's implicit context (the Oracle Product suite(s)) so I am having trouble filtering it down to the parts that I need right now to make a recommendation to my client.
Here are the things that I am trying to figure out:
Does Oracle Performance Manager fulfill any/all of these Performance functions for Oracle databases?:
a. Performance Data Collection (ie., retained in a database)
b. Performance Monitoring (live views of performance)
c. Performance Alerting (live notification of exceeding configurable thresholds)
d. Performance Reporting (this would be nice but not necessary, I know how to write a report from data tables, even in Oracle)
Which can Oracle Performance Manager fulfill for SQL Server databases?
What specific Oracle Product(s) does my customer need to have or purchase in order to get these functions?
Are there any other requirements or restrictions that we should know about?
Any help on this is much appreciated.