These single operational view APIs aggregate performance results from active primary clusters and compute clusters, allowing you to see performance numbers across all the deployed and operational groups. This helps you measure performance of these operational groups and identify sessions that have a negative impact on performance.
They also provide a detailed view that provides additional columns to identify the group.
See the individual APIs for syntax and examples.
- MonitorAMPLoadSV
- This single operational view API aggregates AMP load data across VantageCloud Lake clusters.
- MonitorPhysicalConfigSV
- This single operational view API aggregates node availability data across VantageCloud Lake clusters.
- MonitorPhysicalResourceSV
- This single operational view API aggregates node-specific RSS data across VantageCloud Lake clusters.
- MonitorSessionSV
- This single operational view API can return session information across VantageCloud Lake clusters. The API can also be used to trace query sessions to a compute node.
- MonitorSQLCurrentStepSV
- Use this single operational view API for the SQL step being run on the currently running request across VantageCloud Lake clusters. You can then use this function to get additional details on that session to monitor the current SQL step for the SQL run, provided it is a session that is running a query.
- MonitorSQLStepsSV
- Use this single operational view API for SQL steps being run across VantageCloud Lake clusters. Then use this function to get additional details on that session to monitor the current SQL step for the SQL run, provided it is a session that is running a query.
- MonitorSQLTextSV
- Use this single operational view for the SQL text value for the current SQL step being run across VantageCloud Lake clusters. You can get additional details on that session to monitor the SQL text for the current step, provided it is a session that is running a query.
There are additional APIs that monitor only primary clusters in VantageCloud Lake. See System PMPC PM/APIs and System PMPC Open APIs (SQL Interfaces).