What's new for Foglight for Databases

We are excited to announce a new release of Foglight 8.1.0 . Look what's new: Integration Hub to easily connect Foglight with other...

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 SAP ASE (Sybase) 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 SQL Performance Investigator data available from Foglight REST API or groovy scripting? There are no notes in the documentation about this.

I would like to know if there is a way that I would be able to automate the clearing of alarms that are older then a certain number of days old.

AZUL JRE 7.0.15 vulnerabilities in Foglight (CVE-2025-31257, CVE-2025-53057, CVE-2025-53066, CVE-2025-61748).

Does Foglight support multi-factor authentication (PKI logins) when logging in to the Foglight console and authenticating using the LDAP...

To monitor the operating system a domain account is being used and it authenticates via the Active Directory (AD). Database and Infrastructure...

User does not see the statement details when clicking on the statement in the blocking history dashboard. The user sets the "Tops" drop down to...

Does Foglight support SAML 2.0 for SSO?

The first entry in Query Insights will not pass the correct timeframe when drilling down into SQL using investigate. Subsequent drilldowns work...

A message similar to the following is displayed when viewing database sessions in Oracle or SQL Server agents. Caused by: com.quest.nitro...

Add a column to display the total disk space in the chart under the Logical Disks tab on the Storage Details page.

Spotlight allows existing alarms to be "snoozed". When a Spotlight user snoozes an alarm the alarm is not displayed until the snooze period ends...

We are finding that a newer filesystem type on Linux called Isilon has no limit for number of inodes. Is the newest IC agent able to detect this...

The Log Monitor agent creation wizard includes a Regular Expression tester dialog that can be accessed as a dashboard.

Regarding the Uprocessed objects dashboard for SSAS instances using SSAS Tabular mode, when all the tables in a database are unprocessed list the...

Under the "Enhance Alarms| Customize Rule Name" window under the DB Admin Alarms dashboard add a way to reset the Severity Level values back to...

Does Foglight support configurable grouping of host process information so that the aggregate details for related processes can be seen?

Foglight Installer fails to create database schema on encrypted SQL Server (Force Encryption setting is enabled). Installation wizard throws an...

What does the all in the Foglight license mean? Which is the database cross platform license?

In the HighAvailabilityHostConfig popup the SORT option does not sort the items in a meaningful order. Navigate in Demo environment to...

A user's security team does not allow the Foglight administrator to run SQL queries against the monitored database and return data from the...

If a blackout object is missing (for example when it has been deleted with topologyservice.deleteObject using the Script Console), the...

An alarm is sent from the rule "DBO -Days Since Full Backup" that references an Oracle cluster name but this name can't be found the that...

Can a SQL Server RDS be used as a Foglight Repository?

When entering the PI dashboard page the performance hangs with no changes when the Activity Highlight view is the default loaded view. An auto...

User would like to add a same new ignore list entry for the DB2 diagnostic log to all of the DB2 agents.

The Foglight repository database stores its data within the FOGLIGHTP schema database account.  Each database that is monitored utilizes an...

Is it possible to query all of the SQL queries running collected by SQL PI?

One of the SAP ASE (Sybase) agent collections causes many locks on Sybase SAP and the affected table cannot be promoted to a table lock.

Unable to add a port below 1024 in the Port (optional) field in the SQL Server PI Repository Connection Details popup when creating a new SQL...

When adding a new Oracle RAC database agent specifically monitoring clusterware, the Oracle wizard uses the IP address instead of the hostname in...

In the HighAvailabilityHostConfig popup hundreds of FglAMs may appear, many that have nothing to do with HA. There is no search box and non-remote...

When setting Oracle DataGuard the primary database can be added but when validating instances the following error appears: ORA-12505, TNS...

Are user defined collections available for the MySQL agent?

Within the configuration of the Database alarms (and email notifications) in the Database Alarm Administration dashboard, there are variables...

Is there a way to remove the database platform type in front of every connection on the heatmap? The database platform type (i.e. SQL Server...

Is there a way to programmatically determine if a Foglight Agent Manager is local or remote aside from some kind of naming convention or HA status...

Can the database groups be exported from the Global View UI or queried from the FMS repository?

Cannot validate a connection to a 12c or higher database in the Oracle agent after upgrading from a lower version below 12c (such as 11g).

Following the instructions for importing certificates for database agents would require hundreds of certificates to be created and imported. Is...

A message is red " This feature is disabled because it is not FIPS-compatible " is displayed in the Administration - SQL Server / Performance...

Are there plans to convert the SQL Server cartridge to use credentials and lockboxes for the Database login credentials?

Some details of memory usage within the Infrastructure dashboard from Windows Server machines do not report correctly such as Virtual Bytes...

Is there a way to generate the change tracking report for Multiple Instances at same time?

The following error message is encountered in the FglAM log when connecting to an AIX server. ERROR [FglAM:IncomingMessageResponse[5]-18097] com...

Known issues for the DB2 cartridge

If the DB2 version is 10.1, granting user permission may fail due to inconsistent parameter().

RMI setting in the Agent Administration panel cannot be changed for Azure database agents.

The "User Level Access", "Manage Alarm Blackouts", and "Manage Agent Blackouts" areas are not supported for the Azure SQL database agents.

Known issues with the Azure SQL cartridge

What are the known issues for the Oracle cartridge?

What are the known issues for SQL Server cartridge

Why would Foglight be using xp_cmdshell for monitoring the server? 

When monitoring a cluster server or an AlwaysOn listener when FIPS enabled on the FMS, the following error will occur:  [Foglight][SQLServer...

After applying a new Oracle patch to an Oracle instance, an exception for the DBO_Instance_General and DBO_Usability collections appear. There...

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 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.