How to add SQL PI to a PostgreSQL agent

Installing SQL Performance Investigator (PI) Repository

SQL PI in Foglight enables you to monitor and analyze the performance of selected database platforms in your environment including SQL Server, Oracle, Azure Database, SQL Server Analysis Services, MySQL, and PostgreSQL. To use PI, a dedicated database repository must be installed to store the collected data.

To enable PI from the Databases Dashboard:

1. Click Enable PI under the Monitoring Agent column for the desired instance.

2. On the Administration Dashboard there are two steps to enable PI:
   a. Verify that the monitoring Agent Manager is attached to a SQL PI repository. Select the Agent Manager on which the SQL PI repository manager should be installed. Then click Apply.

   • If the SQL PI repository existed on the selected Agent Manager, no more action is required for the configuration.
   • If no SQL PI repository exists on the selected Agent Manager, the SQL PI Repository Settings appear.

     To use gMSA authentication for connections to the PI Repository, select Local User in the Authentication drop-down. This requires that your FMS and Agent Manager are configured to run as a Windows Service logged on with the gMSA account. The gMSA account requires access to the SQL instance.

   • If the given SQL PI repository user does not have sufficient privileges, the Insufficient Privileges dialog will be displayed. Enter an admin user and password, and then click Grant Privileges.
   • In the SQL PI Schema dialog box, enter the details in the Database Name and the directory path in the Raw Data field.

   b. Select the checkbox of the required agent to configure SQL PI settings. Click Enable. In the SQL PI Repository dialog box, select the required agent manager host and click Apply.
   The SQL PI gets enabled.