Checking a Service Slowest Queries - ABO

Back Office User Guide

Product
ABO
AFS_Version
7.11
Category
Reference Guide

In the Queries display of a selected service in the selected time period, the 50 slowest queries table shows the queries which required a long processing time. This makes it possible to track down the service ability to fulfill users' expectations, or a suspected server overload:

  • The first column is the ranking of the queries speed in decreasing order.
  • The IP and User Agent column gives this information about the visitor who made the query,
  • The Query column lists the full AFS queries syntax.
  • The Reply time column gives the time length in milliseconds required by AFS-QE to deliver a reply.

The table can be browsed with the scroll bar.

queries_slowqueries

A click on a query expression makes it possible to launch it in a browser.

For more information about a slow query, a mouse rollover displays a summary pop-up with information about the parameters used and their values.

queries_slowqueries_details

For more information about AFS queries syntax, see the Search section in AFS Integration Guide.

To display a service slowest queries

  1. Connect AFS-BO and click:
    • Analytics from a service quick view in the Dashboard,
    • in the charts preview in a service quick view in the Dashboard, or
    • Analytics in the Open Module menu.
  2. Select the Queries tab.
  3. Select or change the time range filter option.
  4. Select or change the service view filter in the Filter by View list box.
  5. For your selection, check the queries listed in the 50 slowest queries table in decreasing reply time order. Check the Reply time column for exact measures of time spent by AFS-QE before returned replies.
  6. Roll over your mouse on a query to display a concise summary of the query parameters.