View statistics data

The Statistics tab displays information about the process of publishing views. This is helpful for troubleshooting bottlenecks during the reading of data from the PI System through to the writing of the data to the target. The statistics include the time of each published run; this can be helpful with scheduling when downstream applications read the data from the target.

If you do not see the statistics for an earlier time period, the PI Integrator may have purged these records from the SQL Server where they are stored in order to prevent excessive disk consumption. See Set your record retention policies for more information on when these records are deleted. Use the procedure below to familiarize yourself with the information on the statistics tab.

1. In the My Views page, select the view you are interested in.

2. If the View Details pane is not open, click the button in the lower right corner to open it. Then click the Statistics tab.

   The statistics for the selected view are displayed.

   

3. Click and choose one of the statistics in the table header to view the trend data.

   

4. Click on a row in the table to view additional statistics for the selected run in the right pane.

5. Click Show All Runs to return to the trend view.

   

6. Select a portion of the trend graph to zoom in.

   

   The selected area expands to fill the X-axis of the graph.

   

7. Click the magnifying glass to zoom out.

   

8. Click a node in the trend graph to see details for that run.

   

9. Click View Logs for Run to see the log records for the run.

   The PI Integrator takes you to the Log tab for the selected run.

Enable full reporting

Note: Technical Support uses Enable Full Reporting to collect extensive statistics that help troubleshoot problems with publishing views. Do not turn this feature on unless you are directed to by Technical Support. With full reporting enabled, your available disk space may be rapidly filled.

10. Identify the view that is experiencing performance problems.

11. Go to the view's statistics tab, and click the Enable Full Reporting button.

12. Wait for the next scheduled publication to run for the view.

13. From the statistics tab, scroll to view the run instances that have occurred after enabling full reporting.

14. Click the run instance, and select Download Selected Report. The view instance should have a bar graph icon next to the timestamp, indicating that full reporting was enabled during that run instance.

15. Click the Disable Full Reporting button.