query-threshold-in-seconds

    Monitoring
    Page  added by             Van Halbert

         This section is not complete.

Teiid provides information that represent the current operational state.  This information can be useful in managing load, through-put and tuning.  The data that is available can be accessed using the different administrative tools (i.e., Admin Console, AdminShell or Admin API).

The following is information that details the current load:

Name
Description

Current Sessions
List current sessions connected 

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.  See the Administrative Guide for how to accomplish that task.

The following are data that is meant to provide measurable information:

Name
Description
Comment

Long Running Queries
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. 

Prepared Plan Cache Size 
Current number of entries in cache. 

Prepared Plan Cache # of Requests 
Total number of requests made against cache. 

Prepared Plan Cache Hit Ratio % 
Percentage of positive cache hits 

ResultSet Cache Size 
Current number of entries in cache. 

ResultSet Cache # of Requests 
Total number of requests made against cache. 

ResultSet Cache Hit Ratio % 
Percentage of positive cache hits. 

Query Count 
 Indicates the number of queries currently active. 

Session Count 
 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 

Used Buffer Space in 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 

                        Stop watching space
            |
                Change email notification preferences

       View Online
              |
       Add Comment

Name	Description
Current Sessions	List current sessions connected
Current Request	List current executing requests
Current Transactions	List current executing transactions
Query Plan	Retrieves the query plan for a specific request

Name	Description	Comment
Long Running Queries	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.
Prepared Plan Cache Size	Current number of entries in cache.
Prepared Plan Cache # of Requests	Total number of requests made against cache.
Prepared Plan Cache Hit Ratio %	Percentage of positive cache hits
ResultSet Cache Size	Current number of entries in cache.
ResultSet Cache # of Requests	Total number of requests made against cache.
ResultSet Cache Hit Ratio %	Percentage of positive cache hits.
Query Count	Indicates the number of queries currently active.
Session Count	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
Used Buffer Space in 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