While not strictly required, it is highly recommended that the database systems are monitored. This ensures that the Questra IDM Application Suite will operate at an optimal level with no interruptions of service. The monitoring strategy differs from one database vendor to the next.
Listed below please find some suggested areas to consider when monitoring your database. These monitoring hot points are recommended for database administrator or individuals within your company that have an understanding of database architecture and functionality.
The parameters of an SQL Server database to consider monitoring are:
Local and/or remote monitoring of SQL Servers
Server uptime
Size of database
Buffer cache-hit ratio
Log-file cache-hit ratio
Free log-file space
Data File(s)
Available free space
Status of data file(s)
Transaction log growth
Transaction log shrinking
The parameters of an Oracle database to consider monitoring are:
Tablespace:
available free space
available continuous free space
tablespace fragmentation
status of tablespace
status of rollback segments and waits in them
status of data file(s)
SGA (System Global Area):
buffer cache hit ratio
dictionary cache hit ratio
library cache hit ratio
available free memory