9.3. Session/Query Metrics

Expand

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.