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).