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.
