Read more about Data Workbench’s End-of-life announcement.
The resource monitor vector contains the Memory Budget Monitor and the Number of Queries Monitor.
The following table describes the resource monitor fields used for query queuing.
Field | Type | Description |
---|---|---|
Memory Budget Monitor |
Monitors the query memory used by the current user group. If the current usage is between the Low Threshold and the High Threshold, no new bunches are scheduled until memory usage returns to below the Low Threshold value, for example, as a result of users closing their workspaces. Scheduled bunches are allowed to grow. |
|
High Threshold |
double |
The high threshold for memory usage (bytes). If the memory usage is above this value, no scheduling occurs, and the lowest priority-scheduled bunches are unscheduled one at a time, over a period of time, until the memory usage is brought to below this value. |
Low Threshold |
double |
The low threshold for memory usage (bytes). If Memory Budget Monitor value is below this value, new bunches are allowed to be scheduled, and scheduled bunches are allowed to grow. For example bunches grow when a user adds a visualization to a workspace. |
Reaction Time |
double |
The time constant for the smoothing of the memory usage estimate. Smoothing values avoids reaction to usage spikes. |
Number of Queries Monitor |
Monitors the total number of queries that are currently scheduled for the profile. This resource monitor lets you schedule bunches if the total number of queries remains below the value in the Low Threshold field. This monitor allows currently-scheduled bunches to grow if the total number of queries stays below the value in the High Threshold field. Additionally, this monitor removes bunches of a low priority in order to allow higher priority bunches to be scheduled or grow. However, this setting does not preempt bunches with a priority greater than specified in the Untouchable Priority field. |
|
High Threshold |
The high threshold for memory usage (bytes). If the memory usage is above this value, no scheduling occurs, and the lowest priority scheduled bunches are unscheduled one at a time, over a period of time, until the memory usage is brought to below this value. |
|
Low Threshold |
The low threshold for memory usage (bytes). If Memory Budget Monitor value is below this value, new bunches can be scheduled, and scheduled bunches can grow. |