Chat now with support
Chat with Support

Foglight Experience Monitor 5.8.1 - User Guide

Installing and configuring Multi-appliance clusters Configuring the appliance Specifying monitored web traffic Transforming monitored URLs Managing applications Foglight components and the appliance Using the console program Troubleshooting the appliance Appendix: Third party software Monitoring the user experience Customizing reports The alarm system Integrating the appliance SOAP-based web services

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:

Figure 36. Database page

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.

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.

1
Select the Reset box for the corresponding database.
2
Click Reset button.
3
Click OK to proceed with resetting the database.
1
Select the Check All link located at the bottom of the page.
2
Click Reset button.
3
Click OK to proceed with resetting the database.

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.

2
Click Reset button.
3
Click OK to proceed with resetting the selected item.
Related Documents