Short query bypass

For some extremely short queries, the overhead of queuing can adversely affect their overall performance. For this reason, the adaptive workload manage has the ability to let these queries bypass admission control.

The following queries bypass the adaptive workload manager:
  • Queries submitted via a connection that is associated with the default administration workload (SYSDEFAULTADMWORKLOAD)
  • Queries with an estimated runtime of under one second, or with an estimate cost of less than 25000 timerons, with the following exceptions:
    • Short queries with an estimated usage of more than 2% of the configured sort memory (sheapthres_shr)
    • Any queries that require sort memory and that run when the overall consumption of database sort memory (sheapthres_shr) exceeds 95%

Use the adm_bypassed monitor element to identify queries that bypassed the adaptive workload manager. This monitor element is reported in the MON_GET_ACTIVITY table function, and in the activity event monitor.