How does the data flow from the SQL PI and Oracle PI Engine into the PI repository?
When the SPI Repository agent and PostgreSQL DB Engine is stopped, what happens during this period? Will PI data be collected or stopped?
The PI data collection is stopped.
What is the data flow for PI data storage? Does the Oracle agent or SQL Server agent store PI metrics directly into PostgreSQL directly?
The SPI Engine does not send the data to PI repository directly. There is a record query in memory to cache the data first and then a scheduled runner “Records Consumer” process will retrieve the record from the query and delegate the DLP service to save data to the PI repository.
By default, the schedule interval of “Records Consumer” process is 60 seconds.