Chatta subito con l'assistenza
Chat con il supporto

Foglight for Databases 6.1.0 - Administration and Configuration Guide

Administering and Configuring Foglight Extending Your Monitoring Reach with Foglight Cartridges Administering Foglight Configure Rules and Metric Calculations to Discover Bottlenecks Customizing Your Foglight Environment with Tooling

Administration Home

The Administration dashboard contains links to typical tasks, grouped into three categories: Monitor, Investigate, and Administer Server. It also includes a shortcut to the Support page, where you can access Quest Support and create support bundles, if necessary.

Figure 1. The Administration dashboard.

Use this view to access some of the most common tasks in Foglight, as an alternative to the navigation panel. The following table lists the entries on the Administration dashboard and provides links to the associated dashboards or views.

Configuring Foglight Agents for Host Monitoring

Controlling System Access with Credentials

Edit instance-specific agent properties

Configuring Foglight Agents for Host Monitoring

 

Configure Rules and Metric Calculations to Discover Bottlenecks

Working with Foglight Registry Variables

Suspending Alarms and Data Collection

Download Foglight agent components using the browser interface

 

Manage Foglight Database Performance

Manage Foglight Database Performance

Working with Derived Metrics

Working with Metric Thresholds

Building Script Agents

 

Explore server logs

Monitor Server Performance

Viewing Client Connection Status

Viewing Audited Entries

Viewing Configuration Details

Managing Users and Security

Enable or disable Foglight cartridges

Configuring email notifications

Managing Licenses

Enabling Usage Feedback

Create a new schedule

Setting up Proxy Configuration

Enabling Automatic Communication with Quest

 

Managing Support Bundles

Enabling Automatic Communication with Quest

The Administration dashboard contains links to typical administration tasks. It displays configuration specifics that are of interest to daily administration.

Figure 2. The 5.6 Administration View.

Use this view to access administrative tasks, as an alternative to the navigation panel. The following table lists the entries in the Administration dashboard and identifies the dashboards or views that they link to.

Manage individual agent instances

View and edit global agent properties

Deploy agent packages to Agent Managers

Explore and manage Agent Manager support bundles

Activate or deactivate agent adapters

Manage credentials

Install, view, and manage cartridges

Explore and download agent installers

Explore the topology model

Explore and manage derived metrics

Inspect run-time behavior of derived metrics

Review activity levels

Explore and manage thresholds

Add custom topology types

Explore and manage rules

Inspect run-time behavior of rules

Explore and manage registry variables

Explore and manage schedules

Explore Foglight configuration items

Explore audit log entries

Suspend alarms or data collection

View existing users connected to the server

Configure email notifications

Explore and manage licenses

Explore and manage server support bundles

Enable or disable usage feedback

Explore server log entries

Inspect the server performance

Build custom, script-based agents

Write queries and scripts against the current data set

Explore and manage user access

The Current Statistics view contains information about the installed cartridges, active agents, rules, users, and the Foglight Management Server configuration.

This view displays the following information:

Active Agents shows the number of current agent instances. Each Foglight agent is a process that monitors a specific part of your environment, such as an operating system, application, or server. This number gives you a rough idea on how much data is coming into the Foglight Management Server. If you have no active agents, there is probably a connectivity issue between the agents and Foglight Management Server. If that number is lower than you think it should be, clicking this entry drills down to the Agent Status dashboard. Use this dashboard to find out which agent instances are not connected.
Installed Cartridges shows the number of Foglight cartridges in your system. A Foglight cartridge contains components that encapsulate a specific Foglight functionality. Your monitoring environment includes a set of server-specific cartridges, as well as additionally installed Foglight cartridges that are designed to monitor a specific type of environment. This number includes both the cartridges that come with the Foglight Management Server, and any other installed cartridges that exist in your system. Clicking this entry drills down to the Cartridge Inventory dashboard. Use this dashboard to view the list of all cartridges that exist in your monitoring environment.
Rules shows the number of rules that exist in your monitoring environment. This number includes the rules that come with the Foglight Management Server, any installed cartridges, and also any rules that you create. It gives you an idea of how much business logic is running on your server. That number is proportional to the number of cartridges you deploy. It is also a good general indicator of the environment complexity. The more rules you have, the more work the server is doing to analyze the data and generate alarms. Clicking this entry drills down to the Manage Rules dashboard. Use this dashboard to view, edit, and create rules.
Users shows how many active users are currently logged in, and the total number of users logged into Foglight. They also give you an idea how many people are accessing Foglight. If the users experience slow response, that might be caused by a large number of users and you might want to consider using federation to separate users’ actions from data processing. Clicking this entry drills down to the Manage Users dashboard. Use this dashboard to view and create users.
Server Version contains the server and build version numbers. Clicking this entry drills down to the Foglight Configuration dashboard. Use this dashboard to view the server configuration.
Server OS identifies the operating system of the computer on which the Foglight Management Server is installed. Clicking this entry drills down to the Foglight Configuration dashboard. Use this dashboard to view the server configuration.

The License Information view contains information about one or more installed licenses. Expired Foglight licenses can cause unwanted behavior and this can be prevented by ensuring that your Foglight licenses are valid and up to date. Clicking an entry in this view drills down to the Manage Licenses dashboard. Use this dashboard to view and install Foglight license.

A Foglight license, typically distributed as in a foglight.license file, contains the information about the capabilities that are licensed. Installing this file on the Foglight Management Server enables all of the licensed capabilities.

This view displays the following information:

Installed Licenses contains the total number of all installed Foglight licenses that exist in your system, including current and expired licenses.
Expired Licenses contains the number of expired licenses that exist in your system.
Licenses Expiring in 30 Days contains the number of licenses that will expire in the next 30 days.

The Federation view contains information about the server federation. Federation is a Foglight feature that allows you to monitor large environments that are partitioned into logical units, where each unit acts as a data source, managed by a Foglight Management Server instance (Federated Server), and a Federation Server, that manages the operation of those units, merging their data into a central model. Clicking an entry in this view drills down to the Foglight Server Topology view.

This view displays the following information:

Mode tells you whether the current Foglight Management Server installation is a child (Federated Server) or a master (Federation Server) in a federated system.
Standalone indicates that your server is a Federated Server, or that your monitoring environment is not federated.
Master indicates that the server is a Federation Server.
Children contains the number of children of the current Foglight Management Server installation in a federated system. If this setting shows zero ‘0’, combined with the Federation Mode value of Child/Standalone, that is a good indicator that your monitoring environment is not federated.

The High Availability view indicates if Foglight is running in High Availability (HA) mode. Configuring Foglight in HA mode allows you to run multiple servers in a JBoss partition offering HA. For more information on starting Foglight in High Availability mode, see the Installation and Setup Guide set.

This view displays the following information:

Status shows if Foglight is running in HA mode () or not ().
Peers shows the number of servers in the cluster, not including the current server.

The Administration home page includes a messaging action that allows you to send messages to all Foglight users that are currently logged into the browser interface. The messaging action can be initiated from the action panel on the right. Use it to quickly inform current users of any administration activities that may disrupt their work, or affect it in any way. For example, before shutting down the server, send a message to all active users, giving them sufficient time to save their work.

1
On the navigation panel, under Homes, click Administration.
3
On the action panel, under Actions, click Send Message.
4
Type the message subject in the Subject box in the Send Message to All Users dialog box. For example:
5
In the Message box, type the message text. For example:
Click Expires in and select the from the existing values: 5 Minutes, 15 Minutes, 30 Minutes, 1 Hour, or 24 Hours.
Click Message Level and select from the existing values: Info, Warning, or Error.
8
Click Send.
The Send Message to All Users dialog box closes and a message box appears in the top-right, just above the action panel.

Some Foglight dashboards have reports associated with them. This allows you to run a report based on the current dashboard. You can generate the report using the Reports menu in the top-right corner.

The Administration home page is associated with the Environment Report. Run this report by choosing Environment Report from the Reports menu, and specifying the input parameters in the report wizard.

The report wizard provides more information about the Environment Report and instructions on how to set the input values. For more information about reports in Foglight, see the Foglight User Help.

LogAnalyzer

Use the Log Analyzer dashboard to view the contents of any types of log files, or download log files to a desired location. The time, level, source, and description of log messages appear for each log you view using this dashboard.

1
On the navigation panel under Dashboards, choose Management Server > Diagnostic > Log Analyzer.
In the Log Selector dialog box that appears, select the log file whose contents you want to view.
3
To download the selected log file, click Download and save the file to a desired location.

Schema Browser

The Schema Browser dashboard shows the structure of the data model and allows you better understand the database schema and the existing object dependencies.

1
On the navigation panel, under Dashboards, choose Development Tools > Schema Browser.
To narrow down the search criteria, type a character in the Search by Name box (for example, Host) and click Search.
To search by a regular expression, click Property Search. Type the property name or the topology type, and click Search.
3
When you select an object type, you can sort by various constituents of the object by using the View by options: Properties, Ancestors, Descendants, and Instances.

Database Overview

Use the Database Overview dashboard to see the state of the Foglight database and its activity. This dashboard contains several views that show the row operations, database buffer pool, and/or the number of inserts, deletes, and/or updates. Its appearance depends on the database type in use. For MySQL databases, this dashboard shows four different views: Row Operations, Database Buffer Pool Status, Database Data I/O, and Database Page I/O. For Oracle, PostgreSQL and MS SQL Server databases, the dashboard shows only the Row Operations view.

1
In the navigation panel, under Dashboards, click Management Server > Servers > Database Overview.
2
Choose the database type from the Choose a Foglight Server box.
NOTE: If Choose a Foglight Server does not contain entries for Oracle or MS SQL Server, databases, you might need to grant additional permissions to the database user. For more information, see Grant permissions to explore database activities.

The name of the metrics that contain database reads, inserts, and updates depend on the type of the supported database that Foglight uses to store information, as indicated in the following table.

num_rows_deleted

num_rows_inserted

num_rows_updated

innodb_rows_inserted

innodb_rows_inserted_per5min: #innodb_rows_inserted# * 300

avg_inserts_per5min: avg(#innodb_rows_inserted_per5min for 60 minutes#)

qa_db_inserts : select sum(inserts) from sys.dba_tab_modifications where TABLE_OWNER='xxxx'

delta_db_inserts: delta(#qa_db_inserts from QA_DB_INSERTS_Agent_Table_DB_INSERT_COUNT#)

delta_avg_per5min: avg(#delta_db_inserts for 60 minutes#)

To populate the database charts that are available for Oracle and Microsoft SQL Server on the navigation panel under Dashboards > Management Server > Servers > Database Overview, you need to grant the special permissions on the back-end database for the Foglight Management Server. For a MySQL or PostgreSQL database, special permissions are not required.

Where fmsdbuser is the name of the Foglight database user, as defined by the foglight.database.user parameter in <Foglight_home>/config/server.config.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione