Not mandatory to uninstall standalone PA. This is based on the user's preference, SQL PI has no connection to the legacy PA with the latest cartridge. The user can keep the data from the middleware and only view it via the Standalone PA GUI client.
If there is no long term repository attached to your standalone PA, the data gets recycled after 90 days
on the middleware.
SQLPI has its own Postgres repository on the seleted FGLAM agent manager.
Here are the steps to do brute uninstall of PA for SQL Server if the user wants to go this route:
Please be sure to perform the following steps to make sure the agent is completely uninstalled:
Here are the steps to do the manual brute-force uninstall of the agents:
MONITORED HOST
1) Shut down the agent by stopping the QAM Launcher service.
2) Unregister the service:
a) Open a command prompt
b) cd to <install_dir>/agents/bin
c) run "quest_launcher.exe 3566 -unregister"
d) exit command prompt
3) Remove the <install_dir>/agents/ directory.
If it is a single-tier install, you are done. If you have a separate middleware server, see below.
MIDDLEWARE HOST
If you are not monitoring any other servers and want to completely remove the middleware, you can repeat the above steps on the middleware. However, if your middleware is being used by other collector agents, you will want to follow the below instructions instead:
1) Stop the "QAM Launcher 3566" service.
2) Navigate to <install_dir>\agents\SC_MSSQL\7.0\ directory.
3) Remove or rename the HOST-INSTANCE directory where HOST is the monitored hostname and INSTANCE is the instance name.
4) Navigate to <install_dir>\agents\SC_MSSQL\data\ directory.
5) Remove or rename the HOST-INSTANCE directory where HOST is the monitored hostname and INSTANCE is the instance name.
6) Restart "QAM Launcher 3566" service.