Hany, DPA is definitely more of a performance analysis tool rather than an availability or uptime reporting tool.
Having said that, you could use some of the metrics like round trip time to provide an idea of availability.
As long as the instance being monitored is up and our monitor is up and running, then you'll see a value for that resource. It just runs a select 1 from SQL or a select 1 from dual from Oracle.
That's basically just a ping to the database that we use for observing any network latencies, but could be interpreted as availability also.
I can provide an example query for you to use. What is the monitored instance and what is the repo? SQL Server or Oracle?
Thanx for your feedback, excuse me as I am tottally new to this software, and my boss is keep asking me about that report in the discussion.
I will appreciate if you share the example query, thanx in advance.
And the monitored instance is SQL Server not Oracle.
1 of 1 people found this helpful
OK, I was playing around with the query and thought of an easier way to do this.
Go to alerts, under administrative alerts, there is an instance availability. Set that alert up for the instances you want to track.
Let that run and build up a history of checks about the instance.
You can then either check the availability history by checking on the results of that alert or query the data directly from the repo.
let me know if you want the latter and I can start looking into that.
Thanx very much, that helped.
This one helped me too! But I also like to generate a daily report for this also.
I will try check the dpa repository database and see if I can build a report using SSRS.