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.
|