Looking for Database Profiling Tool
Posted by: Marcello Di Marino Azevedo Dimmy
Date: July 08, 2015 07:37AM

Hello, I'm looking forward for a profiling tool database with the following:

1. Queries per second for a database (with graphs of the variation throughout the day, month and year. It can be queries per second or other time by execution metric)
2. Average response time of queries
3. The average response size (in lines or KB)
4. And these same data broken several dimensions:
4.1. by host
4.2. for table
4.3. In query type (ie identifying a default query)

With this could identify whether increased amounts execution of a query. If the runtime is that it has increased. If a table has worsened much the performance of execution.

We evaluated MONyog for some time, but to be honest we need a tool that collects and keeps these information for a long time to be a baseline of how things are growing.

Until now no software appears to exist that will match these requirements.

I appreciate any suggestions you have.


Options: ReplyQuote

Written By
Looking for Database Profiling Tool
July 08, 2015 07:37AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.