Query Queue User Groups

IMPORTANT

Read more about Data Workbench’s End-of-life announcement.

Table that defines the User Group parameters.

Field Type Description

Name

string

A user-defined name of the user group, such as Analysts.

Policies

vector

Specifies a policy type. Right-click to choose Standard Policy or Daily Schedule.

Standard Policy

A Standard Policy ensures that users with a low priority are incrementally moved up the queue and scheduled, even if higher priority users enter the queue. You can add multiple policies of the same type in a group, and their effect is cumulative.

  • Priority Limit: The limit above which the priority is not incremented. The maximum priority value. You can use this value to keep the priorities generated by this policy in a specific range (for instance, so that priorities for some other group of users are always higher, or so they do not rise above the Untouchable Priority.

Standard Policy Increments

The increment settings for the Standard Policy increase the priority of a query bunch as time passes. This does not force the bunches to be scheduled, but you can use these settings to prioritize users who have been waiting for a long time. The queued parameters affect queries that are currently queued (such as on hold due to insufficient resources to complete them). The scheduled parameters affect queries that are being answered. The priority of a query rises by the number specified in the appropriate increment and increment interval fields:

  • Queued Increment: Sets the priority increment per update while queued. This setting ensures that low priority users are moved up the scheduling queue.
  • Queued Increment Interval: Sets the number of seconds between updates while queued.
  • Scheduled Increment: Sets the priority increment per update while scheduled.
  • Scheduled Increment Interval: Sets the number of seconds between updates while scheduled.

    Note: Setting the increment and interval update rates higher for queued bunches than for scheduled bunches can cause oscillation. (For example, suppose you set the Queued Increment value to 100 and the Scheduled Increment to 0, and set the Queued Increment Interval value to 1 and the Untouchable Priority to be high. If two query bunches come in with a base priority of 0, and there are not enough resources to run both queries at the same time, then one of them is scheduled. After one second, the query that was not scheduled has a priority of 100, and preempts the one that was scheduled. After two more seconds, the one that was preempted now has a priority of 200, and the two switch places again. Neither query finishes, because every two seconds the query that is being computed is preempted so the other query can run.)

Daily Schedule Policy

Lets you change the priority at specific times of the day. This schedule is useful for automated clients, such as Report Server, and when users of the system live in different time zones.

Changes

int

Right-click to add a scheduled priority change. The Change Time is the time of day at which the change occurs. The format is hour:minutes AM/PM. If AM or PM is not entered, the system uses military time.

Priority Limit

int

The maximum priority value resulting from a change. The Priority Change is the amount added to the priority. For example, a value of 0 returns to a default priority. Any other value results in a priority of the default priority plus this number.

Users

vector

Lists the users that are members of the group.

Name: The user’s name as it appears in the Common Name field in the user’s certificate.

Extra Priority: Provides additional priority to the user group’s base priority to determine the starting priority for that user.

On this page