13Data and Usage Statistics

Overview

You can monitor service storage usage data to help you determine whether the database storage limits for a service are less utilized or overutilized.

Usage limits vary for each subscription type. Monitoring statistics also helps you in managing your database storage by deleting, purging, or archiving data that exceeds the storage limits.

View Current Usage Statistics

The Statistics page displays average data and storage statistics as well as historical average data usage and record count.

To view current usage statistics, click Statistics from the Configuration Assistant home page.

The record count and storage graph displays the average record count and data storage statistics for top–10 tables (by data size) for the latest available week, sorted by data size.

The Data Storage table displays the average record count and data storage statistics for all tables, for the latest available week, sorted by total storage.

Data Storage Table

In the Data Storage table, you can export data, format data, and customize the columns you want to display.

The Data Storage table appears as follows:

This figure shows the Data Storage table.

Manage the Data Storage Table

  1. To export usage data to a spreadsheet, from the Menu option, click Export to Excel. Data displayed on the table is saved to a spreadsheet.

  2. To customize the column display, from the View menu, click Columns.

    • Select or clear the columns to be displayed as required.

    • To sort the columns, from the View menu, click Sort.
      • Select a column header to sort.

      • From the Sort menu, click the arrows or select either Ascending or Descending option.

    • To further refine your display, from the Sort menu, select Advanced. In the Advanced Sort dialog box, select the following:
      • Sort By: Select the main column to sort by. For example, Table Name. Select either the Ascending or Descending order.

      • Then By: (Optional). Select the second column to sort by. For example, Storage. Select either the Ascending or Descending order.

      • Then By: (Optional). Select the third column to sort by. For example, Percent. Select either the Ascending or Descending order.

        If you select all the three sort parameters, then the table is sorted first by the main column (for example, Table Name) in the order specified and then within that, by the second (for example, Storage) or third column as specified.

  3. To format the data storage table, click Format. You can resize columns or use the column wrap to format data within the cells.

    • Select a column header.

    • To resize, from the Format menu, click Resize Columns.
      • In the Resize Column dialog box, enter the preferred width.

      • Select the unit, either Pixels or Percent.

      • Click OK.

    • To wrap text within the cells, from the Format menu, select Wrap.

  4. To freeze a column, select the column header and click Freeze. This is useful for tables with multiple columns.

  5. To wrap text within the cells of a column, select a column header and click Wrap.

View Historical Usage Statistics

The Historical Statistics section displays historical data including the number of records in the database and storage utilization.

To view historical data, you can select the following:

  • Month View/Quarterly View/Yearly View link: Displays corresponding monthly, quarterly or yearly average data usage in the form of a graph for a selected table.

  • Table Name: Select the table name for which you want to view historical utilization, that is, the average record count and the average data storage for the selected period (monthly, quarterly, or yearly). Displays data usage in the form of a graph.