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:
Field | Description |
---|---|
Status |
Connection status of the SHR 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. |
Field | Description |
---|---|
Database Availability |
Percentage of time the database was available in the:
Legend description:
|
Field | Description |
---|---|
DBSpace Usage |
Graphical representation of the database space, in megabytes, divided between the following dbspaces:
Legend description:
|
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:
|
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 Click the |
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:
|
Use the Database Monitoring page to view the database details.