Best practice on Data archiving

Forum|Forum|5 years ago
March 22, 2021
1 reply
2524 views

Hello,

We are using the Manufacturing apps 9.1 with a MS Sql server. Since the manufacturing apps are receiving and logging a lot of data it will probably be necessary at a certain point of time to archive some of the data in order to keep the system performant.

Is there any guidance about this?

Which table have to be considered? kpielementvalue, kpivalue, value_stream?

Best Practices

Best answer by hchanana

Hi @gch

Mfg apps already have feature to purge old historical data, PTC.SCA.SCO.HistoricalDataPurgeScheduler is the scheduler used for purging data. You can update the configuration to set how many days data needs to be retained.

More details are available at the below link :

https://support.ptc.com/help/thingworx/apps/r9.0/en/#page/thingworx_apps%2FCustomizing_Operator_Advisor%2Fpurging_the_historical_data_database_table.html

Thanks,

Himanshu

H

hchanana