Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
Effect of configuration on CPU utilizationThe combination of operating-system and HCL OneDB™ configuration parameters can affect CPU utilization. You can change the settings of the HCL OneDB™ configuration parameters that directly affect CPU utilization, and you can adjust the settings for different types of workloads.
Virtual processors and CPU utilizationWhile the database server is online, you can start and stop virtual processors (VPs) that belong to certain classes.
Monitoring virtual processorsMonitor the virtual processors to determine if the number of virtual processors configured for the database server is optimal for the current level of activity.
Using SMI tables to monitor virtual processorsYou can get information from system-monitoring interface (SMI) tables to use to monitor virtual processors.

Using SMI tables to monitor virtual processors

You can get information from system-monitoring interface (SMI) tables to use to monitor virtual processors.

You must connect to the sysmaster database to query the SMI tables. Query the sysvpprof SMI table to obtain information about the virtual processors that are currently running. This table contains the following columns.


Column	Description
vpid	ID number of the virtual processor
class	Class of the virtual processor
usercpu	Seconds of user CPU consumed
syscpu	Seconds of system CPU consumed