Show TOC

Object documentationInteractive Reports for Databases - Capacity Locate this document in the navigation structure

 

These reports contain information about the usage of the available capacity of the selected database. These reports therefore give you information about the capacity that is still free, for example, in the usage of different memory, or of the available CPUs. Host-specific reports relate exclusively to the database host, and not to all hosts on which there are instances of the system of the selected database. In the context of interactive reporting, the following reports give you a quick overview of the development of these metrics over time:

  • Database Usage (  <system ID> on <database host>   Capacity   DB Utilization   )

    The report shows the size and growth of the chosen database; for the database size, the following metrics are output in gigabytes:

    • Database memory used

    • Free memory in the database

    • Memory available to the database in the file system

    Note Note

    For the metrics mentioned, the last reported value of the respective time period is output in each case.

    End of the note.
  • Log Area Usage (  <system ID> on <database host>   Capacity   Log Utilization   )

    The report shows the load and remaining free memory space in the log memory, that is, the memory space that is used for logs in the database. The corresponding sizes are output in gigabytes.

  • CPU (  <system ID> on <database host>   Capacity   CPU   )

    The report shows the CPU load of the selected database host. The value relates to the general CPU load of the host, not to the CPU load due to the database itself. For mor information about these values, seeOperating System Monitor, in which these performance values are described in the context of the Alert Monitor. It shows how intensively the CPU is used, and how much processing capacity is still available.

    The report shows two metrics per system — the mean and maximum CPU load in the specified period.

    In the detail view, a time profile that shows the distribution of the CPU load by time of day, is also shown.

  • File System (  <system ID> on <database host>   Capacity   File System   )

    The report shows the mean load of all file systems of the above host, as a percentage. The detail view shows the mean file system load as a percentage, and the free memory in megabytes, for the ten file systems with the highest load.

    You can also filter by file systems. These performance values are described in the alert monitor under File Systems Monitor.

  • Main Memory (  <system ID> on <database host>   Capacity   Main Memory   )

    The report shows the metrics relating to the size and load of the main memory of the database host. The value relates to the general main memory load of the host, not to the load due to the database itself. For mor information about these values, seeOperating System Monitor, in which these performance values are described in the context of the Alert Monitor.

    The detail view shows the absolute values of the total available and free memory, in megabytes, as well as the main memory load in percent.

  • Paging Rate (  <system ID> on <database host>   Capacity   Paging Rate   )

    The report shows the page-out and page-in rate in kilobytes per second. You can restrict the display to just one of these processes, in the Detail view.

    Main memory usage and paging, together, indicate whether the main memory size is sufficient for the host load. For further information about these values, see Operating System Monitor.

Note Note

  • For information about how you can specify the desired databases and the time interval to be displayed, and how to call interactive reporting, see Using Interactive Reporting.

  • For information about the different display options for the reports for databases with regard to metrics and threshold values, see Interactive Reports for Databases.

End of the note.