Foglight Experience Monitor 5.8.1 - SQL Reference Guide

Foglight Experience Monitor SQL reference

This section provides a description of the Structured Query Language (SQL) databases that the Foglight Experience Monitor uses to store metrics and related information.

By navigating to Help > Support Tools in the Foglight Experience Monitor and clicking on either the Enable Detailed Logging or the Disable Detailed Logging links, you can see queries that the web console uses to obtain metrics from the database. For each page that you navigate to in the web console, logging statements are generated. Search for the text SQL query to see the query that the web console is using.

For details, see these topics:

Database

The following table displays the individual databases that every appliance maintains.

Tables

This section includes detailed information about the following topics:

Metric tables

Metric tables contain all of the standard metrics for resources (or objects) that the system is monitoring. These include all metrics other than distributions and reference counters. The descriptions starting in section 3 include a table showing each column, its type, and a comment. Many of the comments show the actual metric label that appears in the web console. Some labels have a suffix that identifies the exact statistic that the column represents.

NOTE: Some of these statistics do not appear in the web console.

The following table presents these suffixes.

Every resource the system has monitored has a unique identifier that is present in the ResourceID column of every table. The algorithm used to calculate a resource identifier varies from category to category, but it is typically based on some unique aspect of the resource. For some categories (such as Application Component and Service) it is calculated from the unique configuration database item that defines the resource. For categories like Pages and Hits, the identifier is calculated using the URL of the underlying object.

An example of a resource identifier is shown here:

This object is from the Application Component category. The first two characters 2a indicate the category of the object. Convert this number from hexadecimal to decimal and you get 42. See the CategoryID section for a complete list of category identifiers.