Online Help for Administrators > Administration Console Screens > Database Monitoring

Database Monitoring

You can use the Database Monitoring page to view a detailed status of the health and availability of SHR database. This page displays details about the availability of the database for the past one day and for the past seven days. You can also view information about the database, the database space usage, current activities performed by the database, and the physical memory usage trends. Monitoring the SHR host database helps you to identify potential database performance problems and resolve those problems quickly and efficiently.

The Database Monitoring page includes:

Database Information

Field Description
Status

Connection status of the SHR database:

  • indicates that the connection to the database has been successfully established.
  • indicates that there is no connection to the database.

Host Name

Name or IP address of the database server.

Port

Port number to query the database.

Version

Version number of the database.

Database type

Type of the SHR database.

Platform Detail

Operating system installed on the platform that is hosting the SHR database.

Multiplexed Multiplexing capability of the database is enabled or not.
Database Size Size of the database main store in megabytes.
PageSize Amount of memory allocated for storing database entries.
Last Backup Time Time at which the database instance was last backed up.
Last Full Backup Time Time when a full backup was performed on the database.
Last Started

Time at which the database service was last started.

Last DB Polled

Time at which the database was last polled.

Database Availability

Field Description
Database Availability

Percentage of time the database was available in the:

  • Last 7 days
  • Last 1 day

Legend description:

indicates the amount of time, in hours, the database was available.
indicates the time, in hours, the database was not available.

DBSpace Usage

Field Description
DBSpace Usage

Graphical representation of the database space, in megabytes, divided between the following dbspaces:

  • IQ_System_Main: The IQ_System_Main dbspace is created at database creation. IQ_SYSTEM_MAIN is a special dbspace that contains structures necessary for the database to open such as the IQ checkpoint log, IQ rollforward/rollback data for each committed transaction and each active checkpointed transaction, the incremental backup metadata, and database space and identity metadata. IQ_SYSTEM_MAIN is always online when the database is open.
  • IQ_System_Temp: The IQ_System_Temp is a single dbspace for the IQ temporary store created when you create a database. It stores the temporary database files.
  • PMDB_User_Main: This is the user main dbspace that is used for storing user-defined tables, indexes, and table metadata that is specific to SHR data.

Legend description:

indicates reserved space, which is used for storing certain small but critical data structures used during release savepoint, commit, and checkpoint operations.
indicates used space, which is used for storing the main user tables and indexes.
indicates free space, which is the space available for use.

DBSpace Fill Details

Field Description
DBSpace Usage

Graphical representation of the database space, in megabytes, used by the selected store over a period of time; the time period includes:

  • Last 7 days
  • Last 1 day

Current Activities

Field Description
Connection (Used/Max) Number of active user connections to the database and the maximum number of connections the database can handle.
(%) CPU Utilization Percentage of CPU time that is being used by all the activities in the database.
Open Transaction Number of transactions that are currently running in the database.
Active Txn Versions The number of active write transactions and the amount of data they created and destroyed.
Other Versions Other database versions and the total space consumed.
Active Requests Number of server threads currently handling a request.
IQ Threads (Used/Free) Number of threads that are allocated to process queries and data loads and the number of threads that are not in use.
Polling

Click the icon to start current activity polling.

Click the icon to stop current activity polling.

IQ Physical Memory Trend

Field Description
IQ Physical Memory Trend

Graphical representation of the physical memory usage of the Sybase IQ server, in megabytes, for the last one day.

Legend description:

indicates the current physical memory usage trend.
indicates the maximum physical memory usage trend.

Use the Database Monitoring page to view the database details.


© 2010 - 2013 Hewlett-Packard Development Company, L.P.