V8 data retention policy
Last updated 11 November 2020.
V8 SQL Data Retention Policy
Only a system administrator/local host administrator is able to perform all checks or functions.
This code and information are provided "AS IS" without warranty of any kind, either expressed or implied. Furthermore, the author or Olav Treffurt IT Consulting shall not be liable for any damages you may sustain by using this information, whether direct, indirect, special, incidental or consequential, even if it has been advised of the possibility of such damages.
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:
-
Dashboard > SQL Database:
-
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. | Description | Version |
|---|---|---|
| 1 | Select the areas from which you want to delete the data. | 2.0 |
| 2 |
Then press the "execute" button.
V8 Search XE for a "Truncate Table" command on the sql server Note: the data cannot be retrieved. |
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. | Description | Version |
|---|---|---|
| 1 | %UserProfile%\AppData\Roaming\Dynamics Project\V8SearchXE\Errorlog\ | 2.0 |
| 2 | V8 Service: %installation directory location%\Errorlog\ | 2.0 |
Tell us whether you’re sending a problem or suggestion.
Send a screenshot to help show the problem.
Go to where the problem happened, press the Windows logo key + Print screen to take a picture of your screen. Send us the screenshot to support@dynamicsproject.com