Versions Compared

Version Old Version 15 New Version 16
Changes made by

Matthew Wagner

Matthew Wagner

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To refresh the list, click [Refresh this page]. To clear the list, click [Clear list]. For information on improving cache ratio, see the section Lowering the cache ratio.

 

Back to top

 

...

Queries Indicators

Use the Queries tab to monitor and examine the queries that have taken the most time (the slowest). To enable query monitoring, select "Monitoring enabled":

 

Image Added

 

 

Note

Notes:

  • The enabling of SQL query monitoring is not a persisted setting - Monitoring is enabled for the current session only. If the Tomcat server is restarted, the 'Enable monitoring' checkbox is cleared.
  • Enabling SQL query monitoring directly affects XperienCentral performance. Monitoring should not be constantly enabled.

Query List   

After query monitoring is enabled, the speed of all queries performed by XperienCentral will be monitored. In the 'Slowest Queries' list, the slowest query monitored appears at the top of the list. The queries that appear in the list are those that have run since monitoring was enabled or since the last time that the list was cleared using the [Clear list] button.



To see the full query, click it in the list. In the 'Details' box the full query appears. From here you can also copy the query and paste it in another application:



To refresh the list to see the latest queries, click [Refresh this page]. To clear the list, click [Clear list].