To view the database information including the availability, CPU, and memory usage of the database:
Field | Description |
---|---|
Status |
Connection status of the SHR database:
|
Host Name |
Name or IP address of the SHR database server. |
Port |
Port number to query the database. The default port is 21424. |
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 | Total size of the database main store in megabytes. |
Page Size | 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 |
The amount of time the database was available in the:
Legend description:
|
Field | Description |
---|---|
DBSpace Usage |
Graphical representation of the database space, in megabytes:
Legend description:
|
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. |
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.
|