Abstract: Some embodiments of the invention provide a system including agents for inserting annotations into query text of queries run on a set of tables in a set of databases by applications on which the agents are installed, a collector that collects and processes metadata regarding the queries and tables queried, a metadata aggregator that receives the query metadata processed by the collector and aggregates the received query metadata based on a grouping of queries along a shared query metadata attribute that is derived from the query annotation included in the query text data, and a display generator that generates a display of query execution performance for each of a plurality of groups of queries, the plurality of groups having a same value associated with a first query metadata attribute, each group of queries in the plurality of groups of queries having a different value associated with a second query metadata attribute.

Abstract: Some embodiments of the invention provide a system including agents for inserting annotations into query text of queries run on a set of tables in a set of databases by applications on which the agents are installed, a collector that collects and processes metadata regarding the queries and tables queried, a metadata aggregator that receives the query metadata processed by the collector and aggregates the received query metadata based on a grouping of queries along a shared query metadata attribute that is derived from the query annotation included in the query text data, and a display generator that generates a display of query execution performance for each of a plurality of groups of queries, the plurality of groups having a same value associated with a first query metadata attribute, each group of queries in the plurality of groups of queries having a different value associated with a second query metadata attribute.

Abstract: Some embodiments of the invention provide a system including agents for inserting annotations into query text of queries run on a set of tables in a set of databases by applications on which the agents are installed, a collector that collects and processes metadata regarding the queries and tables queried, a metadata aggregator that receives the query metadata processed by the collector and aggregates the received query metadata based on a grouping of queries along a shared query metadata attribute that is derived from the query annotation included in the query text data, and a display generator that generates a display of query execution performance for each of a plurality of groups of queries, the plurality of groups having a same value associated with a first query metadata attribute, each group of queries in the plurality of groups of queries having a different value associated with a second query metadata attribute.