What's new for Foglight for Databases

This guide provides the pre-requisites for optimal deployment. It refers to monitoring the leading RDBMS: Oracle®, SQL Server®, SAP ASE®, DB2 for...

These Release Notes cover the resolved issues, known issues, workarounds, and other important information about the Foglight for DB release.

Amazon DocumentDB is a MongoDB-compatible document store database. It is fully managed by Amazon in the AWS cloud. It offers speed and scalability...

MongoDB Atlas is a cloud platform-as-a-service operated by MongoDB, Inc. the producer of the open source database of the same name. Atlas is a...

Foglight for Databases allows Database Administrators to quickly and efficiently identify performance deviations, determine their root cause...

Foglight for Databases allows Database Administrators to quickly and efficiently identify performance deviations, determine their root cause...

Foglight for AWS Hosts brings comprehensive, non-siloed, enterprise-class monitoring to the industry's leading cloud computing platform.Used...

Foglight for Cassandra quickly and easily detects, diagnoses and resolves performance issues — wherever, whenever and however they occur. Foglight...

Foglight for Redis© is designed to provide enterprises with a powerful tool that can stand alone or act as part of broader cross-platform database...

Foglight for MongoDB rapidly detects, diagnoses and resolves performance issues — wherever, whenever and however they occur. Foglight for MongoDB...

Foglight for MySQL ensures optimal database performance by delivering comprehensive database, storage and virtualization monitoring, plus advanced...

Foglight for Snowflake brings comprehensive, non-siloed,enterprise-class monitoring to the industry's most innovative cloud data management...

Foglight for PostgreSQL rapidly detects, diagnoses and resolves performance issues — wherever, whenever and however they occur. Intuitive web-based...

SAP HANA is an in-memory, relational database management system. It operates primarily as a columnoriented store, but row-oriented tables are also...

Amazon Redshift is a fully-managed, highly-scalable database service on the AWS cloud. It can host data in a Redshift cluster and provide an...

Foglight Cartridge for Oracle allows Database Administrators to quickly and efficiently identify performance deviations, determine their root cause...

Foglight Cartridge for DB2 LUW utilizes a lightweight agent that provides real-time monitoring of all layers of an enterprise application (systems...

Foglight Cartridge for SQL Server allows DBAs to quickly and efficiently identify performance deviations, determine their root cause, perform...

Azure SQL Database is a managed cloud database service that provides the broadest SQL Server engine compatibility and enables customers to migrate...

Foglight Cartridge for MySQL PI

Foglight Cartridge for SAP ASE enables Foglight to monitor SAP ASE database systems. The cartridge monitors database resource utilization for...

PostgreSQL PI in Foglight serves the primary function of providing comprehensive monitoring and performance analysis capabilities for PostgreSQL...

What are the known issues for the Oracle cartridge?

There is a discrepancy between Oracle's own `v$session.SECONDS_IN_WAIT` and blocking duration shown in SQL PI. This data is reported by SQL PI...

Is it possible to change the severity of the keywords in the matching list?  If a new keyword is added to the matching list, which severity will...

Bookmarking a page with the 'preserve time range' selected does not render properly for the database dashboard.

After deleting a license in a FMS, then restarting FMS and the licenses which were deleted are still there. On <fms installer path>/license folder...

When an ASM cluster node is added in the Oracle Database Discovery process it generates a default name such as ASM_CLUSTER_4. How can this cluster...

Getting email alerts as expected, but one is coming frequently. It is just a blank email with no subject line. Sometimes it has been send up to...

How to prevent an event-driven rule from firing when alarm get cleared? An event driven rule was created to forward alarm events from data...

Is it possible to force the Federator Foglight management server to reload new topology settings without a restart of the server ?

Having time difference warnings in the Foglight Management Server (FMS) logs and discarded sample messages in the Foglight Agent Manager (FglAM...

The FglAM has been installed on the Windows client, but there is no option to install the FglAM as a service. How to install the Foglight Agent...

We have a question on Foglight HA.  If we have 2 nodes in Foglight HA environment, and we want to patch the OS on one nodes which will require a...

What permissions are required to be set on WMI name-spaces and DCOM? What can be done when you cannot use a user in the Local Admin group of the...

How to exclude SQL Server jobs from being monitored so that alarms are not received for these jobs?

In an Oracle RAC environment can the Oracle agent monitor Cluster Ready Services (CRS)?

How can the Foglight Management Server be changed, to prevent VERBOSE messages from being written to the Management Server logs?

How to change Foglight Management Server (FMS) from a standalone server to run as a high availability (HA) server?

An FMS on Linux was running as user foglight but it was upgraded using root. Now all the files belong to root and the system is running as root...

On a number of occasions the Foglight Management Server (FMS) or Agent Manager (FglAM) seems to be in a hung state and it is not possible to login...

There is no workload metric in the Databases dashboard (Global View) or workload column appears as "n/a".

A Foglight Management Server or Agent Manager is located on a virtual machine which (VM) runs out of Java Heap Space even though the VM is...

How to setup Foglight connect Microsoft SQL server backend repository using TLS/SSL?

The Foglight Management Server (FMS) and Foglight Agent Manager (FglAM) provides support for moving agents between FglAM clients (that connect to...

How to configure Foglight with windows Single Sign-On (SSO)?

How does one properly configure a Foglight Agent Manager HA (FglAM HA) installation and explain how it functions?

This article describes how to completely uninstall the Agent Manager and remove the init.d script used to run the Agent Manager as a daemon or the...

When restarting the Foglight Management Server or Foglight Agent Manager multiple alarm emails are sent. Is it possible to prevent the multiple...

This article explains how to monitor Oracle 12c and higher multitenant databases in Foglight, including both Container Databases (CDBs) and...

The Foglight Agent Manager (FglAM) is configured for high availability (HA) but the failover is not working.

How to blackout all of Foglight

Cannot install the license file via the Manage License dashboard. Error received is  "Could not execute the requested operation, errors) had...

Foglight generate multiple Fatal Alarm on monitoring agent hosts stated it cannot establish connection intermittently for few hours...

How to disable HTTP access to Foglight and allow only HTTPS access?

How to get a product Walkthrough or Demo

Error thrown when doing an LDAP Test Configuration: An Authentication error occurred during LDAP search. Check application logs. Foglight...

If you did not install the Agent Manager as a Windows® service using the installer, you can do so from the command line after installing the Agent...

On-Demand Data Settings does not work when customer is using Callback instead of RMI The following error message is displayed (in red) in the UI...

The DBSS Long Running Session alarm does not trigger as expected.

Top SQL statements are not collected for a PostgreSQL agent even though the pg_stat_statements extension has been installed.  

What MySQL cartridge and agent rules are available out of the box?

After upgrading to 7.1 or higher, dashboards relying on on-demand queries (e.g. Sessions) have stopped working on the Federator.

Oracle Usability OS connection availability alarms fire in Linux or Unix due to errors like the following in the agent log ERROR   [AGENTNAME...

Is it possible to monitor SQL Server AlwaysOn Availability Groups using the listener address with the Foglight SQL Server agent?

Which grant scripts should be run for DB2 agent monitoring?

When monitoring with the PostgreSQL agent the following error is found in the database agent log. This prevents the host from being monitored...

How can default rules that came with a database cartridge (out of the box) but were deleted by mistake by a user be restored?

Cannot connect to PostgreSQL 15 and higher databases The PostgreSQL log file includes the message: Caused by: org.postgresql.util...

DBSS - Usability OS Connection alarm repeatedly firing while Windows agent connects with no issues. These alarms may be consistent, where the OS...

Blocking history is not seen in SQL PI for when changing the time ranges in the zonar. For example more rows are in “Last 4 hours” than in “Last...

"DBSS - Unable To Check Backup Media" alarm fires because space cannot be queried In some cases messages like the following may appear ERROR...

An Oracle 19c non-cdb database cannot be added for monitoring and the message " For the value “NON-CDB”, no view is set " in red for existing...

What are the issues known to exist at the time of the Foglight 8.1.0 release

For some SQL statements in SQL PI for SQL Server there are no execution plans found. For most statements there is a link to “generate the...

How should SQL Server agents be configured for an Availability Group and a Failover Cluster?

What are agent properties for the Snowflake agent?

The SQL Server Error Log on a monitored instance indicates that the database agent has killed sessions. Why does this occur? 

Foglight Agent Manager (FglAM) fail to establish WinRM connection. Error message: ECHO    DEBUG [WinRMWebServiceManagementConnection[20...

How to update SAML 2.0 hostname used in the metadata.xml if you need to use a custom DNS entry instead of the physical hostname.

How to plan for using GMSA with Foglight

Blank Email Alerts being generated from FMS

Embedded repositories such as the MySQL and PostgreSQL Foglight Management Server (FMS) databases may encounter performance issues or crash due to...

When starting the Agent Manager (FglAM) the following error is encountered: 2014-10-07 13:10:20.000 FATAL [native] Incompatible minimum and...

After navigating to the Email Configuration page (Admin Console | Administration | Setup & Support | Email Configuration), and configuring the...

Looking in the Administration > Cartridges > Cartridge Inventory dashboard, several of the installed cartridges are in a "Partially Enabled" state...

The Foglight for DB2, SQL Server, and Oracle cartridges come with a set or predefined report templates, which provide an analysis of the...

Does Foglight support MS SQL Server Always ON Cluster, with Availability Group and multiSubnet failover, as Database repository?

Foglight Management Server (FMS) - Performance issues.   What are the steps to investigate?

Usability Connection Availability  Does Foglight use telnet to probe the database availability?  If not, does Foglight really connect to the...

Several database installations are running on one server. Each database installation is having its own virtual host name. On the DB dashboards...

How is changing (increasing/decreasing) the FMS JVM heap.memory done? For example to deal with "usr/bin/env error 12 "not enough space" in...

Is there a way to change the user/password for many database agents?

Performance Investigator (PI) displays historical data based on a predefined time pyramid, which controls data resolution and how long it is kept.

A history of the alarms previous fired can be very useful to investigate a technical issue. How can a history of the alarms or a specific type of...

How to add a Topology Type to manage its instance count in the Stale Objects Dashboard (Investigate Objects for Cleanup dashboard)  - Dashboards...

Is there an easy way to find out when a supported Foglight version becomes limited as it reached its end of life (EOL) ? The product life cycle...

Is there a means to set up a global email default for configure a default notification address either for all rules or for individual rule or...

The Foglight MySQL agent requires certain minimum privileges for the MySQL Database User to be able to monitor a MySQL database.

How can a user change the JVM flags used by the Foglight Agent Manager (FglAM) when starting up?

How to config Foglight Integration with SAML 2.0 in Microsoft Entra ID formerly known as Azure AD

The Foglight Management Server (FMS) is very slow. When trying to login to the console or display any dashboard, it can take several minutes to...

What are the requirements for Infrastructure Agent on Windows and Linux and required ports.

Windows Remote Management (WinRM) can be configured quickly on a Windows Server using default settings through the "winrm quickconfig" command.

After a Foglight license expired and a new license was added the Globalview databases dashboard displays only the message  "There is no data to...

This article answers common questions about managing Performance Investigator (SQL PI) data, including retention policy, repository growth, and...

This article provides step-by-step instructions to configure a secure TLS/SSL connection between the MongoDB Agent and a MongoDB server. It...

Which ports are needed to be opened on the firewall to allow monitoring of Foglight for Databases (Oracle, SQL Server, DB2, Sybase)?

When monitoring hosts and database instances using a shared Active Directory (AD) service account across multiple agents, a password change in AD...

Which Foglight Cartridge for SQL Server Availability/Usability alarms will fire against certain system status?  

A Foglight Management Server (FMS) has been running slow after the addition of MySQL and/or PostgreSQL agents. Performance seems proportional with...

How to generate a new self-signed certificate for HTTPS connections to the Foglight Management Server?

This article outlines the required configuration changes for enabling MySQL Performance Schema to support Performance Investigator (PI) in...

Foglight 7.1 upgrade fails if using integrated authentication to connect to Foglight SQL Server repository in the existing Foglight environment...

When trying to add an SQL Sever agent the following error appear on the dashboard: "Value of context key fglamsStatus is null' In the log files...

This article outlines the steps required to migrate the Foglight Management Server (FMS) to a different machine, including scenarios where the FMS...

How to add OS monitoring if the database agent has been installed already? How to enable Operating System (OS) collections on an existing...

Is it possible to change the severity of these alarms, for example from Fatal to Critical?

How to create a Database Alarm Blackout (Scheduled Blackout) using the Database dashboard.

How to create custom rules in Foglight?

For Foglight Database Agents to collect operating system (OS) metrics from monitored Windows hosts, either Windows Remote Management (WinRM) or...

How to schedule a PSO Healthcheck service?

Where can I find step by step guides for upgrading my Foglight

The self-signed TLS certificate used by the FMS for the Tomcat webserver is due to expire very soon on the 13th March 2025. After the certificate...

After upgrading to a recent SQL Server cartridge the drive where the Foglight Agent Manager is located on the PI repository server is running out...

Support bundles generated from the Foglight Agent Manager (FglAM) may be empty or fail to create. This is often caused by large SQL PI statistics...

The Infrastructure dashboard has a Wizard that allows to easily Add Custom Rules . This is briefly documented on the Foglight for Infrastructure...

Is it possible to install the fglcmd utility outside the Foglight server?

How to exclude Ciphers from Foglight the Management Server and Foglight Agent Manager?

The user has two Production Child FMS and 1 FMS Federator. The user has uninstalled several SQL server and Oracle agents from the two children FMS...

Processes  tab in  Infrastructure Host Monitor  dashboard does not show Swap Size for individual process instances. The monitored host is...

The rule Number of Processes fired with an Abnormal number of processes alarm message. Does this mean the Host is struggling or is under heavy...

When will the FMS (Foglight Management Server) external repository be supported on Oracle 23c?

Monitored host performance metrics in Child FMS doesn't match with performance metrics in Federator FMS . Host object shows multiple aliases...

How to set Foglight Agent Manager (FglAM) to use https to communicate with Foglight Management Server (FMS)? How to set FglAM to use SSL...

After experiencing local UDP problems, how can one force Foglight to use TCP in High Availability (HA) mode?

After applying blackout to an agent via script using the AgentBlackoutService interface with the applyAgentBlackout(String agentId, String...

A monitored host requires a 2-step / factor verification logon system which accepts a password for the first part and a token based pin for the...

How to modify e-mails subject and messages adding rule severity variables.

How are credentials secured in Foglight (Management Server Login, Backend Database and Agent credentials) and what encryption is used for passwords?

After starting the Agent Manager process (fglam) via command line, the Agent Manager appears as connected in the Foglight console. Agents start...

Infrastructure Agents not gathering metrics properly:  UnixAgent does not collect metrics from Linux or Oracle Solaris host UnixAgentPlus...

How to move an embedded PostgreSQL to an external PostgreSQL database

The Windows OS Process Agent reads the "Anzeigenamen" (Displayname). However, due to Operating System (OS) language differences, the display names...

Is there Documentation/Tutorial Guide(s) which explains how to design/create custom Dashboards, Views and Reports in Foglight?

The Sybase SAP ASE agent is installed but data cannot be seen in the panels and the logs indicate that the collections are failing.

What are the types of external repositories currently certified or supported by Foglight Management Server?

Is it possible to leave the recipient email address blank/null for alarm email notifications? It is a requirement to leave the email recipient...

Customer would like query the data in Foglight DB through an external application either via ODBC or any other possible means to build report on...

Does the LogMonitor agent use RegEx industry standard?  How to build matching strings?  How to build a match string, that does not contain...

Unable to get session information from Database dashboard.  When navigating to Database | Overview | Activity and see following error: An error...

What is the overhead of the collections in a monitored SQL Server database instance? Is there a way to know the overhead of a specific collection...

Where to find information about troubleshooting FMS Performance issues

Running a Management Server Performance Summary Report,  "User Session Count" always shows as zero although there are users logged in during the...

This article outlines recommended anti-virus exclusion settings to prevent performance issues or interference with the Foglight Management Server...

If we monitor the database in SSL mode, we must import the certificate of the database server into the keystore, What are the steps required to...

Learn how the Hosts dashboard enables you to review a high-level summary of host performance in your environment.

How can users access Alarms AI in Foglight?

After setting the default credentials for the host, these newly created credentials can now be used by the Connection Details wizard to attempt...

How to Setup Multiple Foglight SQL Server Agents for Monitoring Using Advance Mode

How can multiple new Oracle database agents be added to Foglight for monitoring using a single installer wizard panel?

How to add the PI extension to an Oracle agent

How to install and add an Oracle ASM agent

Foglight for PostgreSQL provides a graphic, intuitive method for creating and configuring agents, which can be used instead of Foglight’s default...

How to Upgrade Foglight Agent Manager (FglAM)

How to install a Foglight license from the Foglight Management Server console?

What steps are necessary to add the SQL PI extension to Azure SQL database agents.

How can a SQL Server Integration Services (SSIS) agent be created in Foglight

How can to install a DB2 agent to monitor a PureScale environment

Installing the MySQL license and cartridge

Beginning with the SQL Server 5.9.4.20 and higher cartridge, a SQL Server agent can monitor an instance located on Amazon RDS.

The Agent Status page can be used to create new agents and configure and manage existing agents. 

This article explains how to remove a host from the Foglight Management Server (FMS) when it has been decommissioned or no longer requires...

How to create SQL Server agents that connect to a  PI repository.

How to use the Global Search in Foglight 6.0 and higher

Beginning with the 5.9.7.10 database cartridges, users will be introduced to a Quick Tutorial of the Global View Databases Dashboard using Foglight...

How to add Performance Investigator (SQL PI) to a MySQL database agent

How is the MySQLAgent installed in Foglight?

How can a user view executions plans in SQL Performance Investigator (SQL PI) for SQL Server?

What information is available on the Global View databases dashboard 

Introduction to SQL Performance Investigator (SQL PI) Add-on feature 

Non-administrator roles have been added to give users access to Administer database agent alarms. This role filters out all of the other...

You can override the alarm rules for the selected agents by assigning an alarm template. You can use the template to enable or disable alarms for...

How to add the SQL PI Extension to a SQL Server database agent

How to download and install a Foglight Agent Manager (FglAM)

How can a user defined collection be created for a database agent?

How to grant the permissions for a DB2 group instead of a DB2 user for DB2 database monitoring.

Installing a license and the Amazon Redshift cartridge into the Foglight Management Server

What are the steps necessary to install a new SAP HANA license and cartridge?

What are the steps to install a cartridge in Foglight by Adding it to a Cartridge Inventory of an Existing Foglight Management Server?

How does the SQL Server Error Log filter function?

Installing the MongoDB cartridge

Steps to create an Amazon Redshift agent

Example steps to generate an RSA key for a Linux host for a Foglight RSA credential.

Where can instructional material which explains usage of the Rest API be found?

How to determine the version of Tomcat in use by Foglight?

What versions of OpenJDK and JDK are used with the Foglight Management Server and Foglight Agent Manager?

How to monitor user specific process using the Infrastructure Cartridge (IC)?

Installing the Cassandra cartridge for Foglight.