Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

9.3. Session/Query Metrics

Name
Property
Description
Comment
Session Count
sessionCount
Indicates the number of user connections currently active.
To ensure number of sessions are not restricted at peak times, check max-sessions-allowed (default 5000) is set accordingly and review sessions-expiration-timelimit.
Query Count
queryCount
Indicates the number of queries currently active.
 
Active Query Plan Count
ENGINE_STATISTIC.active-plans-count
Number of query plans currently being processed.
To ensure maximum throughput, see the performance tuning section on QueryEngine and threading.
Waiting Query Plan Count
ENGINE_STATISTIC.waiting-plans-count
Number of query plans currently waiting.
 
Max Waiting Query Plan Watermark
ENGINE_STATISTIC.max-waitplan-watermark
The maximum number of query plans that have been waiting at one time, since the last time the server started.
 
Long Running Queries
longRunningQueries
List current executing queries that have surpassed the query threshold ( query-threshold-in-seconds. ).
Setup alert to warn when one or more queries are consuming resources for an extended period of time. If running too long, an option is to cancel request or increase threshold.