Neoview Workload Management Services Guide (R2.3)

queries and then 30 medium-priority SERVICE2 queries in the waiting queue to start executing
until the system resources reach their limits:
Waiting QueriesExpected
Percentage Based
on Priority Weight
Percentage of All
Executing Queries
Executing QueriesTotal QueriesService Name
60–50=1056%50/90 = 56%0+50=5060SERVICE1
30–30=033%30/90 = 33%0+30=3030SERVICE2
1011%10/90 = 11%1030SERVICE3
Effect of Service-Level Thresholds
For each service level, you can set system resource thresholds, which take precedence over the
thresholds of the WMS system configuration. For example, for a lower priority service, such as
SERVICE3, suppose you set the memory usage to 20% and the CPU busy to 50%. Incoming
queries associated with SERVICE3 automatically go into the waiting queue when the maximum
memory usage and CPU busy exceed the service thresholds of 20% and 50%, respectively. For
more information, see “Configuring User-Defined Services” (page 29).
Setting lower system resource thresholds for lower priority services restricts the number of
executing queries associated with lower priority services and enables more queries associated
with higher priority services to execute on the Neoview platform. This strategy might be useful
for preventing lower priority queries, such as from reporting or ad-hoc applications, from
consuming the system resources needed by higher priority queries.
Configuring User-Defined Services
This section describes how to establish user-defined services for managing query workloads in
WMS. For more information about services, see “How Services Work” (page 25). The examples
show WMS commands that are executed in an NCI session. For more information, see “How to
Execute WMS Commands in NCI” (page 55).
To add, alter, delete, or display information about a service, see:
• “Adding a Service” (page 29)
• “Altering a Service” (page 31)
• “Deleting a Service” (page 32)
• “Displaying Information About the Service Definitions” (page 32)
Adding a Service
Use the ADD SERVICE command to add a service and its priority level and thresholds to the
WMS configuration on a Neoview platform.
Naming the Service
Select a unique and meaningful name for the service. You cannot add a service that already exists,
such as SYSTEM or HP_DEFAULT_SERVICE. You can specify a service name of up to 24
characters. WMS supports multibyte characters in the service name. For guidelines on using
multibyte character sets, see the Neoview Character Sets Administrator's Guide.
Setting the Priority of the Service
You can set the priority of the service relative to other services. Choose one of these priorities,
from highest to lowest:
• PRIORITY URGENT
• PRIORITY HIGH
Configuring User-Defined Services 29