ps -ef | grep -i Foglight
on your Linux server
See KB 138568 for example of servers exclusion at the rule level.
When trying to validate the type of connection being established by the Windows agents, the log file 001 for the agent can be reviewed for the keywords:
Agent logs are available on the directory "<Foglight Agent Manager installation path>\state\default\logs\fb8be857-fbcf-4747-973d-295a8570e581\HostAgents\<agent version>\WindowsAgent\Agent_Name_001.log).
The MultiHostProcessAgent name can be known by doing a search of the hostname in the MonitoringPolicies_yyyy-mm-dd_nnnnnn.xml file. This file is included in the root of the Foglight Management Server (FMS) Support Bundle zip file.
How to generate a Support Bundle review:
From Foglight web console, navigate to the Databases dashboard.
Yes, by using Rules.
Foglight comes with several Rules out of the box, and some of them have an associated EmailAction action. Those can be customized to also execute a CommandAction action, which passes a specified command to the OS where the Foglight Management Server is running.
The URL of the Foglight web console is <IP_ADDRESS>:8080
KB 189372 discusses using the "Groovy Script" field of the Alarm Filter to select the rules and severities of the alarms associated with a service.
See KB 90881 for example regex usage.
The supported Windows platforms for as a SQL PI or Oracle PI repository are:
The supported Linux platforms for as a SQL PI or Oracle PI repository are:
Oracle Enterprise Linux is not supported as a SQL PI or Oracle PI repository.
To install a DB2 agent:
To install a single SQL Server or Oracle agent:
Please consult the Deployment Guide for the Foglight database cartridge available for download from here for the current list of supported monitored databases.
Please refer to the System Requirements and Platform Support Guide available for download from here for the list of supported platforms for the Foglight Management Server (FMS).
High Availability (HA) is not supported for Sybase agents.
PI manages data using an internal time pyramid; the roll-up process runs every 15 minutes.
Time Resolution Retention Period
1 minute 6 hours
15 minutes 3 days
1 hour 2 weeks
6 hours 30 days
1 day 90 days
1 week 2 years
Foglight cartridges run on the Foglight Management Server (FMS), which is the operation framework. Therefore, Foglight Management Server must be installed before installing a cartridge.
To install the Foglight
Permissions required for database monitoring depend on the database that is being used. Please refer to the Foglight for Databases deployment guide available for download from here for most recent list of permissions required.
Please refer to the System Requirements and Platform Support Guide available for download from here for the current list of the supported platforms for the Foglight Agent Manager (FglAM).
Changing a database agent collection frequency and timeout
Foglight collects data by running scripts (i.e. shell, sql, wmi) on a regular basis. Some these frequencies may be determined by the collection frequencies that are set in the agent properties.
For example, the Backup Config, Backup Jobs, and Backup Type Status collections by default are set to a Collection Interval or 21,600 seconds (six hours) for the realtime, online, and offline frequency modes. This is done to minimize the impact of performing queries regularly agent all of your monitored hosts.
Collection frequencies can be adjusted to reduce or increase the frequency of how often a particular collection is run against a monitored host. This is set on a agent-by-agent basis.
Here at Technical Support it is Quest’s policy not to be on call for assistance with Upgrades or Installations as we deal with break/fix issues at time of the problem. However, we will provide you with as much information as we can to help you to be successful on your upgrade. Should you run into a problem during the upgrade or Installation we would recommend opening a Service Request and we will respond as quickly as possible to address any issues you may have encountered. Most installations and upgrades proceed without issues.
The Foglight cartridges for DB2, Oracle, and SQL Server has a user defined query (user defined collection) component that allows users to provide custom SQL statements to retrieve data. With this solution you would be able to run custom queries to gather data in addition to data the Foglight SQL Server cartridge provides without installing an agent on the monitored server.
The available sampling frequencies are as follows:
There are three main components:
NOTE: The product components can be either distributed over different machines — preferable in large or growing environments — or centralized.
Please refer to the Foglight for SQL Server or Foglight for Oracle deployment guides available for download from here for more information.