Database monitoring
The term database monitoring refers to the tasks associated with examining the operational status of your database.
Database monitoring is a vital activity for the maintenance of
the performance and health of your database management system. To
facilitate monitoring, the database management system collects
information from the database manager, its databases, and any connected
applications. With this information you can perform the following
types of tasks, and more:
- Forecast hardware requirements based on database usage patterns.
- Analyze the performance of individual applications or SQL queries.
- Track the usage of indexes and tables.
- Pinpoint the cause of poor system performance.
- Assess the impact of optimization activities (for example, altering database manager configuration parameters, adding indexes, or modifying SQL queries).