Category
Topic
Subtopic
Monitoring PGA statistics in the Oracle agent (4378860)
What PGA statistics are monitored in the Oracle agent? ... How can a user monitor when the Oracle database is reaching its maximum PGA (Program Global Area) allocation? ... What steps can you do to remedy the situation?
SQL Server agent kills sessions (4373370)
The SQL Server Error Log on a monitored instance indicates that the database agent has killed sessions. ... An "idle" session, is any session that was opened by the database agent but remained open on the server side, even after being closed on the client side (FglAM).
Information about the DBSS - Worker Thread alarm (4290002)
The percentage of Worker Threads used (100.00%) is greater than the defined threshold 95.00%. ... I can't find an explanation for the alarm. ... What does it mean? ... SQL Server uses the native thread services of the Windows operating systems so that one or more threads support each network that SQL Server supports simultaneously, another thread handles database checkpoints, and a pool of threads handles all users.
How to add a RSA or DSA credential in Foglight (4378827)
You can select any of the following type of credential depending on your system configuration or preference: ... RSA Key - Generate a new RSA key using the following commands (use -m PEM to ensure the key is in PEM format): ssh-keygen -t rsa -m PEM
Configuring MySQL for Performance Investigator (PI) (4309267)
In order for PI to collect data, the MySQL Performance Schema must be enabled with the required instrumentation. ... by modifying parameters in the <em>AWS DB Parameter Group</em> using the AWS console (UI) or AWS CLI commands.
Two of the same alarms will be reported in one instance after a failover for an AlwaysOn Group (4378770)
When a SQL Server monitors the instance which has database set up as a replica of the AlwaysOn group. ... When the AlwaysOn group performs a failover, then the monitored instance will report two alarms with the same messages about the failover.
Monitoring Google Cloud SQL Server (4369925)
Is Foglight monitoring of SQL Server on Google Cloud Platform (GCP) supported? <p>Foglight monitoring of SQL Server on Google Cloud Platform (GCP) is supported in the 6.1.2.10 and higher releases of the SQL Server cartridge.<br><br>SQL Performance Investigator (SQL PI) of SQL Server on GCP is also supported in the 6.1.2.10 and higher releases of the SQL Server cartridge.</p>
Cannot enable PI on MySQL Aurora 3.x (4378740)
When running MySQL on an AWS RDS Aurora Engine at 3.0 or higher release, when the user tries to enable PI an error to the following is encountered in the FMS log file. ... In Aurora version 3 and higher the mysql database is read-only.
"No pg_hba.conf entry" connection error in PostgreSQL agent (4226693)
The pg_hba.conf file is the authentication gateway to the PostgreSQL server. ... Users must be specified in this file in order to connect to the server. ... The entry for the user can be in several different formats, but the important thing to remember is that the user must be able to connect from the agent location and that it should be allowed to connect to all databases.
"An error has occurred." shows on SQL Agent Error logs dashboard (4227970)
The red error message "An error has occurred. ... Please check your logs" will be shown in the Logs | SQL Agent Error Logs page, when monitoring SQL Server 2017 on Linux. ... WORKAROUND ... None ... STATUS
CLI installer mssql_cli_installer.groovy will only work if the CSV file has 2 or less records (4306148)
Command to run mssql_cli_installer.groovy will only process if the CSV file contains 2 or less records. ... If more than 2 records are in the file, the command appears to be running, then it looks like it completes, but there is no output file created and no databases are added to Foglight.
"Fail to populate PDF report - error rending view please check application log" when running DB2 Executive Database Summary Report (4229396)
Error rendering view "subcategories table", please check application logs ... DB2 Metric Breakdown ... Error rendering view "Operation Statistics − RO", please check application logs ... WARN [runReportTask-0] com.quest.wcf.core.context.marshaller.AtomicTypeUtils - Error loading data object data source type: foglight-5, data source id: foglight-5, data object id: /alarms/fb100b25-a01c-4fa0-8f06-798e623d33c7 msg: java.lang.NullPointerException in view: 'system:fsmreporteditor_generator.generateReport' in top-level view: 'system:foglight_reports.main' for user: 'foglight'
CLIENT_PLUGIN_AUTH error when connecting to MySQL instance (4226418)
When installing a new MySQL agent, the message "CLIENT_PLUGIN_AUTH" is required occurs when connecting to a MySQL 5.1.5.1 instance. ... java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required
Configuring the SAP HANA system for Foglight agent monitoring (4228989)
What database setup and resource tracking requirements must be made to configure a SAP HANA system for Foglight agent monitoring? <div> <h4><strong>Database User Setup</strong></h4> <p><strong></strong>To configure the monitoring of an SAP HANA system, the Foglight agent requires a database user with sufficient privileges on the SYSTEMDB and each tenant database for which monitoring is desired.
Permission denied for table pg_subscription (4378647)
The following message is filling the PostgreSQL agent log file monitoring Amazon RDS platforms. ... WORKAROUND ... None ... STATUS ... This issue was logged as defect FOGPGSQL-192 and has been fixed in the PostgreSQL 7.3.1.13 and higher cartridge.
Snowflake agent properties (4369842)
What are agent properties for the Snowflake agent? ... Organization – The organization that this account belongs to. ... The Foglight topology created for this account will be under this organization, so it is very important that any accounts belonging to this organization are all provided the exact same string in the agent properties.
Private key provided is invalid or not supported SecretKeyFactory not available error when adding Snowflake agent (4378575)
Add the following to the baseline.jvm.config file and restart the FglAM, this can be done manually directly in the file or using the JVM Config column in the Agent Managers panel.
Top SQL statements are truncated in the Top SQL database agent pages (4295027)
Top SQL statements are truncated in the Top SQL drilldown pages of the DB2 agent for the monitored database. ... Change the setting in the Agent Properties increasing the Top SQL size. ... Navigate to Administration | Agents | Agent Status
SQL Statements and Top SQL statements not displaying within the SQL Statements dashboard (4314120)
All other database related data is being collected. ... CAUSE 1 ... Within the agent configuration (viewed via the latest agent log file), the Top SQL collection appears to be disabled: ... CAUSE 3
Testing Blocking and Deadlocks in the SQL Server agent (4378359)
How can a user test deadlocks and blocking in the SQL Server agent? ... Lock: is done by database when any connection accesses the same piece of data concurrently. ... One connection needs to access a piece of data .
SQL Server deadlocks are missing and not displayed in dashboard (4310482)
Foglight is not picking up deadlock activity on a monitored SQL Server instance. ... Foglight generates an email notification or alarm advising a deadlock condition has occurred, but the Activity dashboard does not display any data indicating a deadlock has or is occurring.
In Sybase Top SQL tab some SQL statements are missing (4259593)
Please increase the maximum number of Top SQL rows retrieved in the Sybase agent properties and restart the Agent. ... From Foglight UI go to: Administration | Agents | Agent Status ... Select the Agent in question
When do SQL Server Availability and Usability Alarms Fire? (4293896)
Which Foglight Cartridge for SQL Server Availability/Usability alarms will fire against certain system status? <p>Below are the expected alarms to trigger when the monitored system is in a particular status.
How monitor SQL Server database instances in DMZ? (4310607)
How can be Foglight be installed to monitor SQL Server database instances on hosts in a DMZ? <p>There are two options available to monitor a SQL Server host located in the DMZ outside of an internal firewall.</p> <ul><li>Install a Foglight Agent Manager in the DMZ and then have the FglAM communicate with the hosts also in the DMZ.
DBSS_Databases collection times out (4378373)
DBSS_Databases collection times out with messages like the following in the agent log ... java.lang.RuntimeException: Failed to execute collection [DBSS_Database], reason=The query has timed out.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All