Database size

Home > Select Project > Stat/Report > DB size

It aggregates the sizes of tables for each database and provides trend data in a chart. You can identify and manage the trend in database capacity growth. You can prepare for rapid capacity increases by identifying them in advance.

Database size can affect the performance. You can prepare to troubleshoot performance issues because the increase in size can delay the query execution. It is also required to identify and prevent problems in advance that may increase the size due to incorrect queries or database structure issues.

The trend in database size helps you understand usage patterns and data growth. You can predict future capacity requirements and take possible actions. Monitoring these changes helps you optimize the resources and costs.

Basic screen guide

1. Set the time to search in Time. You can also select a lookup time by clicking the green button.

2. Select a target to view in Instance.

3. Select .

Checking the changes over time

• Size trend

  You can visually see the changes in the total size and usage of the database over time. The chart displays the sizes for each database in different color. Hover your mouse over the chart and move it left and right to view the details. You can see information details on the sizes for each database at a specific time point through the tooltip.

• Disk used

  You can check the changes in disk usage for each mount point during the query period. By comparing the usage at the start and end points, you can visually see how much the disk usage has increased or decreased.

• Size details

  It provides capacity details for each database in a table format. You can check the names (DB NAME) for each database, total capacity (TOTAL), and changed amount (CHANGED). If you select a database, you can see information details in the Table size (TOP 50) section.

Downloading the viewed data

You can download the searched data as a CSV format file. Select and then select Size details or Table size (TOP 50).