Best practice on Data archiving

[gch]

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?

[hchanana · Accepted solution]

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

[gch]

Hi,

which data will be purged?

The logged values, the KPIs?

[gch]

Since it is specific to the operator advisor, I'm not sure that it will help...

[hchanana]

Hi @gch : This scheduler purge both operator advisor and mfg apps data (from value streams) older than the specified days