Category
Tema
Subtema
Idioma
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.
Configuring the password file for Oracle ASM monitoring using SSL (4378182)
For Oracle ASM monitoring using SSL the password file should be configured correctly. ... ASM (Automatic Storage Management) is a system used by Oracle to manage storage for databases. ... It requires a password file to securely control administrative access, particularly when connecting remotely or performing critical operations.
SQL PI passing FMS credentials causes PI panel not to load (4375345)
After upgrading to 7.2.2.10 and higher, the username and password or service account that is running the FMS application is being passed to retrieve data from SQL PI instead of previously entered PI repository credentials.
Using a default database other than sybsystemprocs in the Sybase SAP ASE agent (4378167)
Can a default database other than sybsystemprocs be used in the Sybase SAP ASE agent? ... The Sybase agent stored procedures are hardcoded to be written to sybsystemprocs. ... WORKAROUND ... None.
Configuring PG_STAT_STATEMENTS in Azure PostgreSQL Flexible Server (4378160)
In order to set up Statement monitoring in the PostgreSQL agent monitoring Azure Database for PostgreSQL you'll need to first follow these steps to enable the pg_stat_statements extension for collecting query statistics.
Investigating and resolving OS (Operating System) credential issues (4226257)
Investigating OS connection issues can be challenging when there are numerous credentials present in the FMS. ... This knowledgebase article describes some techniques to identify and resolve common OS credentials issues for Windows and Linux / Unix.
How to enable Kerberos Debug at the FglAM level (4309953)
How can Kerberos debug be enabled in the Foglight Agent Manager (FglAM)? <ol><li>Change line 7 of [FGLAM_HOME]/state/default/config/auth.login.config to the following: ... <pre class="language-markup" style="background: #efefef;padding: 8px;display: block;border: 1px solid rgb(204, 204, 204);overflow-x: auto;"><code>com.sun.security.auth.module.Krb5LoginModule required client=TRUE refreshKrb5Config=TRUE debug=TRUE;</code></pre>
Adding CRS agents for monitoring Oracle clusterware (4301649)
Receiving alarms about the CRS software, which is used for monitoring Oracle Clusterware, requires creating CRS agents. ... NOTE: The Monitor More Clusterwares wizard supports the monitoring of a single CRS cluster.
Databases on a secondary replica are read-only, so the grant script cannot create the user in the database. (4227786)
Databases on a secondary replica are read-only, so the grant script cannot create the user in the database. ... The foglight user may still not be able to read data from these read-only replicas until the users will be synchronized.
Issues running "Index Fragmentation" report (4301081)
In some cases, the following errors can be seen when running the report: ... "Too many databases requested. ... For SQL versions lower than 2012, can only produce fragmentation report on one database at a time"
Investigating and troubleshooting dashboard metric, rule, and alarm issues (multiple causes) (4308244)
What generic steps can be followed to troubleshoot and investigate database agent rule and alarm issues such as ... Top SQL). ... Analogous SQL or OS queries can also be run directly against the monitored host to see the results outside of Foglight.</p> <p> </p> <h2>Agent Configuration</h2> <p>Each agent is managed by the settings configured in the Agent Status Properties for each agent.
SQL Server Explain or Execution Plans are missing from SQL PI Analyze Plans page (4373224)
Why is there a difference? ... Plan query length is over the limitation of [400000] for handle [0x0500220034210a7445fff23566500000001000000000000000000000000000000000000000000000000000000] ... Most plans which are not resolved because their length exceeds the 400,000-character limitation.
DBO Days Since Backup does not monitor Oracle INCR Level 0 incremental backup types (4302513)
While using the Cartridge for Oracle, an instance is backed up once a day using RMAN. ... The "DBO - Days Since Full Backup " rule incorrectly fires because the alarm is not validating the INCR LEVEL 0 as a FULL backup.
What does "Other Waits" mean in SQL PI? (4246132)
Other wait indicates miscellaneous instance waits consisting of infrequent or otherwise special purpose wait states that should, in most cases, be very close to 0. ... Although this deviation does not necessarily indicate a performance problem, the performance history should be reviewed.
What are Background Processes in SQL Server? (4231940)
in SQL Server, Background Processes are typically system processes and jobs that work without user intervention. ... SQL Server Agent is a background process responsible for automating routine tasks in SQL Server, such as backups, scheduled queries, database maintenance, and alerts.
Background processes and SQL PI queries are filtered from SQL PI (4369626)
Database related background processes and SQL PI's own internal queries are filtered out by default SQL PI. ... How can the background processes and PI internal queries be viewed within the PI SQL statements for SQL Server, Azure SQL, MySQL, and PostgreSQL?
What is the meaning of Background Activity in Oracle? (4260219)
In Oracle, Background Activity refers to processes and tasks that run in the background of the database environment to support its overall operation. ... These activities are typically handled by background processes and threads that do not require direct interaction with users but are essential for database performance, resource management, and maintenance.
Query Plan & Top SQL collections fail in SQL Server availability groups (4289941)
In SQL Server, when a database is part of an availability group and the instance has databases that are secondary servers and are currently accessible for connections and when the application intent is set to read only then live features such as Generate Query Plan (from the plan cache) and Top SQL collections will fail because the database is an AlwaysOn Secondary with the Readable Secondary feature set for READ-INTENT ONLY
DB2 Database Availability alarm fires for Standby databases (4377927)
A message similar to the following appears in the DB2 agent log file. ... The rule is coded to look in the Error log for SQL Code -1776 to identify that the database is HADR. ... When a database agent user id does not have access to read the DB2 Log file then the rule will not recognize the database as standby.
Oracle Check Permissions Script does not report missing privileges (4377380)
The Check Permissions script used to validate Oracle permissions was inconsistently reporting results, sometimes returning "PL/SQL procedure successfully completed" when there were revoked or missing privileges.
What does the "DBO - Session Summary Total Limit" rule measure? (4377853)
The Total Sessions Limit shows the percentage of the total session limit being used in the Oracle database. ... This alarm fires when the number of sessions currently connected to the database is about to exceed the value defined in the init.ora parameter file.
MongoDB agent fails to collect data. (4377547)
MongoDB agent fails to collect data and below error is seen in the agent logs. ... Duplication of a parameter in the agent properties. ... Please follow below steps to identify and remove the duplicate parameter from the agent properties dashboard.
What is Run Queue Length? (4275432)
The CPU run queue is a holding area for threads and processes that require the CPU when the CPU is busy serving other processes. ... The run queue length is an indicator of whether the system has sufficient CPU resources for all the processes it executes.<br><br>High values along with high CPU utilization, indicates that the system requires faster or more CPUs to handle the given load.<br>
Network Wait vs I/O Wait (4267590)
Network Wait is the time spent waiting for messages to be sent or received over the network interface. ... I/O Wait is the time spent waiting for disk input/output operations to complete.<br><br>Network performance is measured in number (per second) of packets sent and received.
What is Latch Wait? (4260764)
Specifically, what do the following mean in PASS:<br><br>LATCH EX<br>PAGELATCH EX<br>PAGELATCH SH Latch wait is time spent waiting for internal locks (latches) to be released.<br><br>There should be performance advisories pertaining to latch waits that are generated when latch waits occur (latches, database file configuration both show information on this topic).
Asociación de nuevos productos
- Herramientas de autoservicio
- Base de conocimientos
- Notificaciones y alertas
- Soporte de productos
- Descargas de software
- Documentación técnica
- Foros de usuarios
- Tutoriales en video
- Aviso de actualizaciones de páginas web (RSS)
- Comuníquese con nosotros
- Soporte Técnico
- Ver todos