PI OLEDB enterprise on PI AF node performance Issue

Discussion created by lduarte on Oct 1, 2012
Latest reply on Oct 1, 2012 by spilon



We have a customer that they are expecting a performance issue in PI OLEDB Enterprise.


They are creating a new Web services ( via PI OLEDB Enterprise ) to access the PI Data Archive and PI AF Data via Sharepoint website.


The problem happens when the customer try to access a webpage and the the data takes more than 10 seconds to be load.


We access the PI AF node and we install the PI OLEDB Enterprise 2010 R3 to check if the problem was in the newtwork or on the AF Node.


When we run the query via PI SQL Commander ( on PI AF node ) the first time that we run the query the time was 14 seconds and the second time was 2.3 seconds ( the difference is explained by the caching that is done automatically by the OLEDB Provider Enterprise).


So the problem is not the network.


We check that UAC was not enable on windows server 2008.

We check that they have not another PI AF database.


We modify their connection string, and add "Use Agent = 0".


Do you have any idea what can cause this performance issue?


Best Regards,