Neoview Workload Management Services Guide (R2.5)

Table 3-3 Tools for Monitoring Query Performance and System Resource Usage (continued)
Actions That You Can TakeCapabilitiesNeoview Management Tool
Analyze the query statistics in the
Repository to determine why some
queries used too many system resources
or took too long to run. Use that data to
configure compilation rules that hold
or reject those queries before they start
to run.
Look for CPU usage trends and
anomalies that help you establish the
WMS service thresholds.
Provides historical data and statistics
about these entities on the Neoview
platform:
• Queries initiated through ODBC
and JDBC, including queries
managed by WMS
• Processing nodes (CPUs)
For more information, see the Neoview
Repository User Guide.
Neoview Repository
Use this tool to query the Neoview
Repository.
Enables you to run and save reports
against the Neoview Repository.
HPDM: Metric Miner
Use WMS commands in NCI scripts to
monitor resource usage, the status of
the WMS services, and query statistics.
You can use WMS commands to
manage the WMS configuration and
perform various actions, such as
stopping or starting services or the
entire WMS system, and holding or
releasing queries, services, or the WMS
system. For more information about
WMS commands, see Appendix A
(page 171).
Allows scripting of WMS commands
for monitoring and taking actions. NCI
supports Perl and Python scripts. For
more information about NCI scripting,
see the Neoview Command Interface
(NCI) Guide.
Neoview Command Interface
(NCI)
Use WMS commands in SPJs to monitor
resource usage, the status of the WMS
services, and query statistics. You can
use WMS commands to manage the
WMS configuration and perform
various actions, such as stopping or
starting services or the entire WMS
system, and holding or releasing
queries, services, or the WMS system.
For more information about WMS
commands, see Appendix A (page 171).
Allows you to encapsulate a
sophisticated set of WMS commands
in Java methods to support complex
management procedures. For help
implementing WMS commands in
SPJs, please contact your HP Support
representative.
Neoview Stored Procedures in Java
(SPJs)
As you gain more information about the query performance and system resource usage, you can
continue to refine the WMS configuration to meet the needs of your query workload environment.
Analyzing and Refining the Query Workload Configuration 45