How to move DB agent associated to SQL PI repository A to SQL PI repository B?
How to Re-Assign a DB agent to a different Oracle or SQL Server SQL SPI Repository
How to reassign DB agents to a different SQL PI Repository
You may need to re-assign a supported DB agent to a different Oracle or SQL Server SQL (SPI) Repository for load balancing or general organizational purposes.
A migration utility for SQL Server and Oracle agents has been included beginning with the 18.104.22.168 database cartridges. The migration tool allows you to perform resource balancing between the agent managers running Oracle agents with and without the SQL PI extension installed.
The SQL PI Repository stores data associated with SQL Performance dashboard when enabled on a database agent. This data is referenced and displayed in the FMS Web Console and database agent dashboards.
The SQL PI functionality has the following constraints:
When a new or existing DB agent is marked to be SQL PI enabled the following logic is used:
Once an agent is migrated to the new FglAM, the new migrated agent will keep submitting data to the existing topologies so no data will be lost.