Analyze Query Speed

(Available for the Content and Agentstore components, IDOL Proxy, and DAH.)

You can check the response speed of the ACI server by sending a query from the Query Speed Analysis tab in the Monitor page. IDOL Admin analyzes the response speed and displays a number of statistics. The Query action using the TimingAnalysis parameter returns this information. If the server is responding more slowly than expected, you can attempt to improve performance by altering query action and configuration parameters. For more information about improving query performance, refer to IDOL Insight.

To analyze query speed

  1. Enter a query into the fields. For more information, see Query the Server.

  2. Type the number of times to repeat the query into the Set number of repeats text box. Increasing the number of repetitions increases the accuracy of the calculated averages. You can also increase the repetitions to simulate a query that is run frequently, because it eliminates factors such as loading data from disk.

  3. Click Query.

IDOL Admin runs the query and displays the following information.

Query duration
Total elapsed time The time elapsed since the query was sent.
Total query time The time taken to process the query.
Current query duration The length of time that the current query has been running.

IDOL Admin displays the statistics for the individual subindexes in the data index as both a table and a pie chart. You can select whether to display the Average, Final Run, or Total statistics.

Average displays the average results calculated from all the query repeats.
Final Run displays the statistics for the final repeat of the query.
Total displays the cumulative statistics for all of the query repeats.

The table displays both the Count and Time(s) values for each subindex. Click Duration or Count to switch between either set of statistics in the pie chart.

Clicking Show Details opens a box displaying the entire set of statistics. Clicking View Query Results opens the Query tab in the Console page in the Control section, where you can view the results returned for the queries.

© 2013 - 2013 Hewlett-Packard Development Company, L.P.