AnsweredAssumed Answered

Ways to optimize the PI Server Reads (tuning parameters)

Question asked by mchaaya on Dec 11, 2017
Latest reply on Dec 11, 2017 by rschmitz

Hello everyone,

We're running into an issue at our organization, where PI Client tools are taking time to fetch data form the PI server for the heavy duty tags.

I'm looking for ways to optimize the PI server as much as possible.

We have Windows server 2012 R2 64bit. 32GB ram, CPU E52690v2 (2processor). HP G8 DL380. Pi server 2015R2.

We know that the issue is with these tags which are being archived at a very high rate (required). we're talking these tags have around 7000-8000 values per day.

If i open PI DataLink and try to fetch 1 year of data for 1 tag, calculated average 1 value per day, it takes around 1min20s to display the data. this seems high.

While the query is running, i notice that in the Microsoft Resource Monitor the Disk usage for piarchss.exe is jumping to 10MB/s while all of the archives files start to open one after the other all the way until the query gather all of the data required and display it in excel.

peformance2.jpg

We have 10K HDD.

The CPU is barely over 2% , RAM we have 32GB and running at 44% and doesn't jump during the query.

Here below are the PI tuning parameters. if you can identify anything which could help please advise.

pituning_general.JPG

pituning_archive1.JPG

pituning_archive2.JPG

Thank you and Best Regards

Outcomes