ODBC Server Installation and Management Manual

HP NonStop ODBC Server Installation and Management Manual—429395-002
5-1
5
Managing NonStop ODBC Server
Resources
This section discusses the management of NonStop ODBC Server resources, and
gives suggestions for allocating resources and handling usage.
Customers often need to run lengthy and resource-intensive queries. The need to
manage system use often increases when system resources are shared by a mixed
workload of small queries and large batch-like queries.
To manage the system resources optimally for such queries, the NonStop ODBC
Server provides two facilities to monitor and control system resource use.
•
The resource accounting facility provides the ability to record the resource usage
for satisfying the end-user database requests.
•
The resource governing facility provides the capability to control the resources
used by SQL statements. For example, a limit can be set for the amount of
resources to be used for a single query; if the limit is exceeded, the query can be
stopped.
Resource Accounting
The NonStop ODBC Server resource accounting facility collects metrics used to
estimate resource usage and, thereby, to predict resource cost. Data is written directly
to an SQL table. Two types of metrics are collected: CPU time and SQL statement
statistics from SQL/MP.
The NonStop ODBC Server resource accounting facility can be turned on or off and
can be configured to record the data at the end of each statement or at the end of a
user session. These options are defined as part of a user profile.
Resource Governing
Management of system resource varies depending on the customer’s resource-usage
objectives. At times, limiting the resources for a particular user might be sufficient; at
other times, setting priorities for resource use might be the best decision.
One customer might decide that all simple queries should be run at a higher priority
than medium queries, and medium queries should be run at a higher priority than
complex queries. The customer might specify that a simple query is one that has a
total cost less than 5,000, a medium query is one that has a cost in the range of 5,000
to 200,000, and a complex query is one with a cost greater than 200,000.