Monitoring
Teiid provides information about its current operational state. This information can be useful in tuning, monitoring, and managing load and through-put. The runtime data can be accessed using administrative tools (i.e. Admin Console, AdminShell or Admin API).
Query/Session details:
| Name | Description |
|---|---|
Current Sessions |
List current connected sessions |
Current Request |
List current executing requests |
Current Transactions |
List current executing transactions |
Query Plan |
Retrieves the query plan for a specific request |
There are administrative options for terminating sessions, queries, and transactions.
Metrics:
Session/Query
| 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 through-put, see the QueryEngine section in Threading on tuning. |
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. |
Buffer Manager
For tuning suggestions, see Memory Management.
| Name | Property | Description | Comment |
|---|---|---|---|
Disk Write Count |
ENGINE_STATISTIC.buffermgr-disk-write-count |
Disk write count for the buffer manager. |
|
Disk Read Count |
ENGINE_STATISTIC.buffermgr-disk-read-count |
Disk read count for the buffer manager. |
|
Cache Write Count |
ENGINE_STATISTIC.buffermgr-cache-write-count |
Cache write count for the buffer manager. |
|
Cache Read Count |
ENGINE_STATISTIC.buffermgr-cache-read-count |
Cache read count for the buffer manager. |
|
Disk Space Used (MB) |
ENGINE_STATISTIC.buffermgr-diskspace-used-mb |
Indicates amount of storage space currently used by buffer files |
Setup alert to warn when used buffer space is at an unacceptable level, based on the setting of max-buffer-space |
Total memory in use (KB) |
ENGINE_STATISTIC.total-memory-inuse-kb |
Estimate of the current memory usage in kilobytes. |
|
Total memory in use by active plans (KB) |
ENGINE_STATISTIC.total-memory-inuse-active-plans-kb |
Estimate of the current memory usage by active plans in kilobytes |
Plan/Result Cache
For tuning suggestions, see Cache Tuning.
| Name | Property | Description |
|---|---|---|
Prepared Plan Cache Size |
PREPARED_PLAN_CACHE.total-entries |
Current number of entries in cache. |
Prepared Plan Cache # of Requests |
PREPARED_PLAN_CACHE.request-count |
Total number of requests made against cache. |
Prepared Plan Cache Hit Ratio % |
PREPARED_PLAN_CACHE.hit-ratio |
Percentage of positive cache hits |
ResultSet Cache Size |
QUERY_SERVICE_RESULT_SET_CACHE.total-entries |
Current number of entries in cache. |
ResultSet Cache # of Requests |
QUERY_SERVICE_RESULT_SET_CACHE.request-count |
Total number of requests made against cache. |
ResultSet Cache Hit Ratio % |
QUERY_SERVICE_RESULT_SET_CACHE.hit-ratio |
Percentage of positive cache hits. |