|
This page aims to inform
you of the variations in database software. Even businesses
which use reliable internet services from providers such as O2
UK and the latest equipment installed can encounter problems.
However, having a good knowledge of the software which you are working
with can be the first step in resolving the issue.
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.
|
