Report performance troubleshooting commands

Set the debug level of the SQL report cache daemon.

Print information of all crashed daemons.

If daemons crash frequently, contact customer support for assistance.

Disable debug message.

Enable debug messages to run SQL diagnostic commands.

Show the log receive rate.

Show message receive rate. One message might contain multiple logs.

Show disk quota for all logging devices.

Show the maximum number of pending and running reports, and the current number of pending and running reports.

Show if hcache creation is able to catch up.

Show the hcache size.

List the number of log tables, hcaches, and the time to generate each chart in the report.

Show SQL query connections and hcache status.

Show a specific report’s hcache status.

Show a summary table of all configured reports with their configuration status.

List the processes running on the FortiAnalyzer system.

Show system performance statistics such as CPU, memory, and I/O usage.

Show the system status such as platform type (hardware or VM), firmware version, system time, disk usage, and file system format.

Use this information to check if the hardware is overloaded. This information also helps you and customer support to quickly identify any issues and narrow down the investigation.

• Ensure Version is the latest software version.
• Check the hardware Platform Type. Consider upgrading older hardware, especially older hardware running newer software such as 5.2 or later.
• Ensure File System is Ext4. Other file systems will likely cause performance issues.