Foglight Experience Monitor 5.8.1 - Installation and Administration Guide

Database configuration

The Database page, accessed by clicking Configure > Appliance > Database, provides you with a number of administrative tasks for managing the appliance’s database.

The links and controls available on this page enable you to perform tasks such as:

For a complete list of database types and their description, see the Foglight Experience Monitor SQL Reference Guide.

Viewing the database page

The database page contains a list of databases, and for each database, details about metrics, storage, and its data retention periods. For each database you can view information about its size and usage. The Size value for each database refers to the hard disk space used by the database. The Usage (%) value refers to the percentage of space on the database partition that the database is occupying.

The Size and the Usage columns display a total value for all of the databases included on the Database page. These values display the overall space that the databases are using and do not include values for any configuration databases.

The Database Partition Usage metric, viewed on the Metric Analysis > System Health > Database Partition Usage page displays a total value for the database partition that includes configuration database values. If you compare the total percentage on the Database page with the metric value on the Database Partition Usage page, the totals will not match. For information about database totals that include configuration databases, see the Database Partition Usage metric in the Foglight Experience Monitor Metric Reference Guide.

NOTE: The total values on the Database page will not match the total amount of the System Health - Database Partition Usage metric.

In addition you can click the Details link which allows you to drill down to detailed information for a specific database. For information about viewing database details, see Viewing the database details page.

You can also reset an individual database or all databases on the list. For information about resetting a database, see Resetting a database.

Viewing the database details page

You can view detailed information about a database by clicking the Details link that appears beside any of the databases on the Database page. The Details page displays information about categories and time periods. The values that are displayed on this page are stored in the System Database category. For more information about System Database category, see the Foglight Experience Monitor SQL Reference Guide.

The Categories section displays all of the metrics that are contained in the database. For example, there are several application categories (application component by city, and application component by region) that provide metrics from a different perspectives associated with the Application database. Each category displays information about its size, which is the hard disk space used by the category, and the percentage of the entire database that each category is occupying. The percentage column (%), when added, should total a 100% and should reflect the total for the same data stored in the System Database category.

The Time Periods section displays the time periods associated with category data. Time periods reflect the breakdown of all the data for all the categories in the database. For example, "Hourly" is going to include hourly data for the entire complement of Application Component category such as Application Component, Application Component by City, Application Component by Country, Application Component by Server, Application Component by Subnet and Application Component by Region. Each time period displays information about its size, which is the hard disk space used by the time period, and the percentage of the entire database that each time period is occupying. The percentage column (%), when added, should total a 100% and should reflect the total for the same data stored in the System Database category.

For information about resetting a category or time period, see Resetting categories and time periods.

Resetting a database

Sometimes it is necessary to delete data from a database. Resetting a database, deletes all of the data in the database and then reinitialize it.

IMPORTANT: Use this capability with extreme caution as all metrics collected up to this point are discarded. The process of resetting the metric database may take several minutes depending on the size of the database. Attempts to generate reports during this time may generate error messages in the web console.

IMPORTANT: when you perform a reset the numbers displayed on the Database and Details pages do not immediately reflect the change. It can take up to 15 minutes for the metrics to change as a result of the reset.

IMPORTANT: The following options should be used with extreme caution; they can modify or delete all configuration settings and metrics in your system.

At times, it may be advantageous to delete metric categories and time periods for each database. Using this capability, you can clear the entire categories or time period list or remove a single resource.

Categories are configured on the Configure > Reporting > Categories page. Categories that are not selected on this page do not collect metrics during monitoring. Although, these categories will display on the Categories section of the Database > Details page, with a zero value since no metric data has been collected. For more about Metric Categories, see Metric categories. When resetting categories for a database, you are resetting only the appliance that you are logged into regardless if this appliance is part of a cluster of appliances.