This section describes how you check the query response time. Query response time is total time that is taken when you run any select query on Adeptia Suite repository or log database.
By default, query response time is not displayed. To view the query response time, all you need to define the query through which you want to measure the query response time. You can define the query to run on repository database as well as on log database.
 

Steps to configure SQL Query

  1. Go to ../Serverkernel/etc folder.
  2. Open monitoring-matrix.properties file (see Figure 3).

    Figure 3: Default Monitoring Parameters XML page

  3. To define the query to run on Adeptia Suite's repository database, change the value of abpm.monitoring.repository.sql property
    For example: select * from AU_FileSource
    Whenever you use repositoryDB as matrix flag in request URL, this query will run on the repository database and the response time will be displayed in the result. 
    In SQL query you can use any table name of the backend database
  4. To define the query to run on Adeptia Suite's log database, change the value of abpm.monitoring.log.sql property.
    For example: select * from AU_TransactionData 
    Whenever you give logDB as matrix flag in request URL, this query will run on the log database.
    In this SQL query you can use any table of backend database.
  5. Save the file and restart the Kernel and WebRunner.
  • No labels