V8 data retention policy

Last updated 11 October 2021

 V8 SQL Data Retention Policy



The installation process requires elevation, so you'll see the standard Windows elevation prompt after you run the installer.

Data is stored in two categories: Data for which you want to view trends and performance troubleshooting data. You can specify the different types of data to be retained in the data repository. It is recommended that you store data for which you want to view trends over a longer period of time than performance troubleshooting data that you are more likely to need only for a short period of time.

Data is stored for each category for an indefinite period of time. This means that data in your data repository is never automatically deleted. However, you should ensure that there is enough storage space available for potentially large amounts of data.
This also applies to the folder where you store your data files (html files, csv files, etc.)

The current size occupied by the data tables and associated indexes in each category is displayed in the table. The current total size of all categories is also displayed.

Use all the following SQL queries:

  1. Dashboard > SQL Database:


     

  2. Delete rows in the results area if you want to delete records in the database. If you want to delete all rows, you can use a delete query.
    To do this, use the SQL Server Management Studio (SSMS)

Reduction of data retention

The amount of disk space you have available in your data repository to store collected data. If disk space is a problem, you might want to delete high volume data more frequently.


How does V8 Search XE handle deleted data?

For analysis data, the graph displays an empty area for data that no longer exists. This is the same as on the overview pages.

Data for which you want to view trends

In the v8 sql database, all data tables for displaying trends are displayed at the beginning of the table names with "V8C".
All other data for the system or as performance data for troubleshooting.


 Delete data from the V8 system tables
 Files > System Check


 

Pos. Version
1 2.0
2 2.0
 Finding the V8 Search XE log files
Log files collect information about the application while you are using it. These files are useful to us if you have encountered a problem.

Good feedback makes V8 Search XE better. If you have time, it would be great if you could send us the log files to support@dynamicsproject.com from time to time. Thanks a lot.

Log file locations
By default the log files are stored in:

Pos. Version
1 2.0
2 2.0

V8 Search XE. Designed and built by Olav Treffurt IT Consulting. Copyright © 2021 DynamicsProject.com. All rights reserved.

Trademarks
Microsoft, Microsoft Dynamics, Microsoft Dynamics NAV, Dynamics 365 Business Central, Windows, Windows Server, and the other products listed on the trademarks page of the Microsoft website are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners.