Performance Investigator (PI) collects a lot of workload and performance data about the activity which runs within a database instance. This information is saved in the PI embedded repository which is separate from the Foglight repository. As a result, the PI data is only presented in the PI dashboard and is not available for custom dashboards and reports as other information collected by the Foglight cartridge is.
To address this problem, several custom views have been created. They allow building custom dashboards and reports to provide more flexibility in consuming performance information.
This article describes the views available and provides instructions on how to use them.
Note: Information presented is relevant for both Foglight for SQL Server and Foglight for Oracle, unless otherwise indicated.
The following custom views are available with the SQL Server and Oracle database cartridges:
These views take the instance name as a parameter, and each view can be made into report and scheduled to run periodically.
Here is a step-by-step explanation of how to create custom dashboards using one of the PI views.
Create report based on PI views