Technical Tip: How to check SQL Database rebuild progress on FortiAnalyzer

Description

This article explains how to monitor the progress of an SQL Database rebuild. Rebuilding the SQL database can be a lengthy process if FortiAnalzyer has a large volume of raw logs.

Scope

FortiAnalyzer.

Solution

Before FortiAnalyzer 5.2.1, the only direct method of determining the status of the rebuild was to use the following command:

diagnose sql status rebuild-db

The following is a sample output:

The log SQL database rebuild has progressed to 6%.

Starting in FortiAnalyzer 5.2.1, the rebuild status is also displayed in the FortiAnalyzer dashboard.

 

Other indirect methods of observing the progress of the SQL database rebuild include:

diagnose log device<----- Shows the database value increase for devices & ADOMs.

diagnose sql show db-size <----- Will show the database size increasing.

• Log View: Logs will start to appear as the database is populated.