My project ran well for servral months. Nowdays Tag History module has interrupted data storage. I found that CPU utilization of database server reaches 40%. Now I restart the database server. It dropped below 10%。Besides, Partition Units changed from 1 month to 1 week. Max Active connections in the database has been expanded.
And database server property follows:Processor Interl(R) Xeon(R) silver 4114 CPU @ 2.2GHz 2.19GHz /4 core /16GB RAM.
The total Tag Provider number is nearly 200,000. Different Historical Provider uses different store metricx. Someone store metricxs average time is 38.6 per second. Aggregate Throughput is bettween 17.8 and about 100 per second.
At present, the problem of database has been temporarily solved. I would like to know whether there is a better solution for my case or not. Do I need to buy another tag history module for store data?
Looking forward your reply!