Top Tables by Space Used Report

In environments where hundreds of components are monitored, there is a possibility that the eG backend database may run out of space. To conserve database space, it is essential to optimize the space used by database tables. For this purpose, eG Enterprise offers the Top Tables by Space Used report.

This report helps administrators identify those tables that are consuming the maximum amount of space in the eG backend database over a period of time, and isolate those tables that are growing at a rapid pace. The pointers provided by this report enable administrators to initiate remedial measures such as reducing the frequency of the test that is dumping data into the table, reducing the retention period of the detailed diagnosis of the tests etc.

To generate this report, do the following:

  1. Select the Top Tables by Space Used option by following the menu sequence: REPORTS BY FUNCTION -> Domain-specific Reports ->eG Enterprise.

  2. As soon as you click the Top Tables by Space Used option, the report will be automatically generated and displayed in the right panel (see Figure 1).

    Figure 1 : The Top Tables by Space Used report

  3. The generated report (see Figure 1) consists of the following sections:

    • A Summary section (see Figure 1) that displays the space used by the files in the eG backend database and the total number of files available in the eG backend database.

    • A pie chart (see Figure 1) that displays the distribution of Top 10 tables (in the G backed database) based on the disk space utilization. Using this pie chart, administrators can identify the table that is hogging the maximum amount of disk space.

    • The Top Tables by Disk Space Used section (see Figure 2) lists all the tables available in the eG backend database along with the amount of space utilized by the table on the disk and the percentage of space used on the disk.

      Figure 2 : The Top Tables by Disk Space Used section

  4. By closely analyzing this report, administrators can identify those tables that are hogging the resources unnecessarily and require clean up at more periodic intervals.

  5. By default, the generated report is based on a set of default specifications displayed in the More Options drop down window. These settings are hidden by default. If you want to view and alter these settings (if required), click on the button. The default settings will then appear in the MORE OPTIONS drop down window (see Figure 3). The steps below discuss each of these settings and how they can be customized.

    Figure 3 : The default settings for generating the Top Tables by Space Used report

  6. By default, the dispk space utilized by the tables is reported in MB in the generated report. If you wish view the disk space utilization of the tables in a different measurement unit (GB or TB), then, you can do so by choosing an option from the Table Unit list (see Figure 3).

  7. By default, All Tables option is chosen from the Filter by list (see Figure 3) indicating that the report considers all the tables available in the eG backend database for report generation. If you wish to generate a report on the tables that utilize less than 10 MB disk space, then, you can pick an appropriate option from this list and proceed with report generation.

    You can even specify your own disk space utilization criteria to generate the report. For this, you can pick the Others option from the Filter by list.This will then reveal the Table size list (see Figure 4). By default, Greater than option is chosen from this list and 20 is displayed by default in the adjacent text box. The measurement unit of the Table size is displayed in MB. You can even pick a measurement unit from this list (see Figure 4).

    Figure 4 : Choosing the Others option in Filter by list

  8. In large environments, reports generated using months of data can take a long time to complete. Administrators now have the option of generating reports on-line or in the background. When a report is scheduled for background generation, administrators can proceed with their other monitoring, diagnosis, and reporting tasks, while the eG manager is processing the report. This saves the administrator valuable time. To schedule background processing of a report, you can either select the Background Save - PDF option or the Background Save - CSV option from the Report Generation list. In this case, a Report Name text box will appear, where you would have to provide the name with which the report is to be saved in the background. To process reports in the foreground, select the Foreground Generation - HTML option from this list.

    Note:

    • The Report Generation list will appear only if the EnableBackgroundReport flag in the [BACKGROUND_PROCESS] section of the eg_report.ini file (in the [EG_INSTALL_DIR]\manager\config directory) is set to Yes.
    • The default selection in the Report Generation list will change according to the Timeline specified for the report. If the Timeline set is greater than or equal to the number of days specified against the MinDurationForReport parameter in the [BACKGROUND_PROCESS] section of the eg_report.ini file, then the default selection in the Report Generation list will be Background Save - PDF. On the other hand, if the Timeline set for the report is lesser than the value of the MinDurationForReport parameter, then the default selection in the Report Generation list will be Foreground. This is because, the MinDurationForReport setting governs when reports are to be processed in the background. By default, this parameter is set to 2 weeks - this indicates that by default, reports with a timeline of 2 weeks and above will be processed in the background.

  9. On the other hand, if the Background Save - PDF or Backgrounf Save - CSV option is chosen from the Report Generation list, you should specify the Report Name. Then, clicking on the Run Report button will not generate the report and display it in this page for your benefit. Instead, a message indicating that the report is being processed in the background will appear. This will be accompanied by a link that will lead you to the page that lists all the reports that are being processed in the background, and their current status. If background report generation fails for a report, you can regenerate that report using this page, or can even delete that report if need be. On the other hand, if background processing successfully completes for your report, then, you can view a PDF of the report by clicking on the icon in the Report Generated and Saved page that appears.

  10. Figure 5 displays a generated report that lists the tables that utilize a disk space of more than 2000 MB.

    Figure 5 : A report generated by filtering tables utilizing disk space above 2000 MB