|
The following is a list of database software and the differences
between each of them:
Sybase
 Server
uptime- Local and/or remote monitoring of Sybase Servers
- Amount of free log-file space
- Data file size for each database
- Data and log-file cache hit ratio
- Reports the number of:
- databases available
- granted and waited page and table locks
- transactions and deadlocks pr. second
- database page reads/writes pr. second
- disk IO, disk reads and disk writes
- committed transactions
MS SQL
- 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
- Number of:
- databases
- active users
- logged-in users
- deadlocks per second
- transactions per second
- database reads
- database writes
- flush waits
- latch waits
- full scans
- Transaction log growth
- Transaction log shrinking
Oracle
- Table space:available free space
- available continuous free space
- table space fragmentation
- status of table space
- status of rollback segments and waits in them
- status of data file(s)
- Status of individual tables:
- amount of extents
- amount of chained rows
- SGA (System Global Area):
- buffer cache hit ratio
- dictionary cache hit ratio
- library cache hit ratio
- available free memory
- sort ratio, disk vs. memory
- Oracle users sessions:
- number of connected users to the database through SQL Net
- amount of memory consumed by session
- Oracle internal alerts through alertlogfile:
- license high watermark
- internal error messages
- Redo log contention
- Database objects state:
- objects with invalid state (triggers, procedures and views)
- invalid indexes
- database objects that cannot expand
- Oracle internal resource monitoring
- Multiple Oracle server monitoring
- DB knowledge base
- Hint Assistance/Editor:
- easy to extend the Database Assistance Knowledge Base being
used by operators and administrators when retrieving/ analyzing
the Oracle health report.
|
