How to add the SQL PI Extension to a Foglight SQL Server Agent?
This video is applicable for Foglight 5.6.11, 5.7.1, and 5.7.5
SQL Performance Investigator (SQL-PI) is an extension to the standard Foglight for SQL Server Cartridge. SQL-PI adds Real-time and historical SQL-PI functionality and provides the following key features:
The SQL Performance Investigator extension does require a add on license.
Alternative to the Video, step by steps instructions in less details are included below.
Find SQL Performance Investigator and select it to enter the PI admin screen
The SQL Performance Investigator administration screen allows enabling and disabling the SQL PI extension for the SQL Server agents.There are some requirements to adhere listed in the Sizing guide.
If the unlicensed notice is showing, there is a need to obtain at least a trial key for this SQLPI extension add on. Licensing information and a listing of key features are also included and accessible from the screen.
The repository needs assigning for the agent or agents. Click Assign.
The SQLPI screen displays the agent managers reporting into the Foglight that are candidates for hosting PI repositories to assign to agent or agents.
Select the Agent Manager and click apply. The procedure will verify the system resources. If the resources don’t check out, another indication will pop up with some options
Upon successful completion, the process will assign the SQLPI repository host to all the selected agents listed on the screen but Enabling PI to first the selected agent. To enable PI on the remaining agents (If applicable), check box the remaining agent and click enable SQL PI
Click apply to accept the highlighted host. Changing the SQLPI repository in this step will override the original repository selection for the agents, in which is an option if that is the desire.
Once the verification is done the SQLPI indicator is active. Click save changes and an commenting dialogue pops up with a section to add comments about the installation.
The PI feature is also reflected on the databases dashboards. Under Monitoring Powered by should illuminate the green SQLPI indicator. The agents since now containing the SQL PI add on will also be referenced in the Databases SQLPI dashboards.