Storage options

30 May 2021 188 views 0 minutes to read Contributors

The following areas can be configured

Area Covers
Storage Type Choose where to store the analysis data

 

JSON

Stores all the data in JSON files under the folder JsonData

AIM_AllIndexTasks All indexes executed or to be executed
AIM_General Version number of AIM
AIM_IndexAnalysis All indexes from all tables from all databases including new indexes
AIM_IndexTasks All indexes executed or to be executed
AIM_Profiles Profile information
AIM_Statistics All the individual runs and summary information
AIM_TableAnalysis All the tables from all databases including their properties

 

SQL Server

Stores all the data in SQL Server.

AIM_AllIndexTasks All indexes executed or to be executed
AIM_General Version number of AIM
AIM_IndexAnalysis All indexes from all tables from all databases including new indexes
AIM_IndexTasks All indexes executed or to be executed
AIM_Profiles Profile information
AIM_Statistics All the individual runs and summary information
AIM_TableAnalysis All the tables from all databases including their properties

 

SQLite

Stores all the data in a SQLite database.

AIM_AllIndexTasks All indexes executed or to be executed
AIM_General Version number of AIM
AIM_IndexAnalysis All indexes from all tables from all databases including new indexes
AIM_IndexTasks All indexes executed or to be executed
AIM_Profiles Profile information
AIM_Statistics All the individual runs and summary information
AIM_TableAnalysis All the tables from all databases including their properties

In this article