How to Add the SQL PI Extension to a Foglight SQL Server Agent

Welcome to Dell software Foglight video solution. This video will cover how to add the SQL performance investigator extension to a SQL Server Agent. My name is Darrell Williams, and I'm a technical product specialist. The objective of this demo will cover how to add the SQL performance investigator extension to a previously created Foglight SQL Server Agent. The process has some minimum requirements. Please review the prerequisites and requirements as a setup reference. Also consult the Foglight docs mentioned below. To add the SQL PI extension, log into the Foglight web console with your Foglight user. Now, click on Databases to access the databases dashboard. Check box the agent or agents for adding the extension to, as this process can assign the feature to multiple agents simultaneously. These selected agents should not have the PI indicator listed on the monitoring status Powered by. Keep in mind, selecting multiple agents will get assigned to the same PI repository. Click Settings and Administration. Find the 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 to, listed in the sizing guide. If the unlicensed notice is showing, that means there is a need to obtain at least a trial key for this SQL PI extension add-on. Licensing information and a listing of key features are also included and accessible from the screen. I will finish conducting setting up that SQL PI extension on a Foglight management server licensed to add the SQL PI feature. Following that same trick to land back on the SQL performance investigator administration screen, note that unlicensed banner indication is not present. Moving along with the process, first, the repository needs assigning for each agent. The repository host can facilitate up to 100 agents, based on the deployment needs and/or supported hardware sizing. Assigning offers flexibility to add or section agents to the same or different PI repository host. Click Assign SPI Repository. The SQL PI screen displays the agent managers reporting into the Foglight management server. They are candidates for hosting PI repositories to assign to agents. These hosts have already been identified fulfilling some minimal requirements, such as supported OS, Windows 64-bit. Note the other suggest requirements and recommendations. The pick list arranges the agent managers by name, OS, and SPI repository existing status, denoted by a green check mark or not. If selected, the hosted PI repositories that exists will just link the agent to the repository for its data storage. Otherwise, selecting the PI repository that doesn't exist on the host showing no check mark, the process will ultimately create the PI repository database then link the agent to it. The created PI repository currently will be a unified postgres database. Select the agent manager. I would choose one that doesn't have a PI repository to demonstrate the process taking place for that selection. Click Apply, and the procedure will verify the system resources. If the resource don't check out, another indication will pop up with some options. Upon successful completion, the process will assign the SQL PI repository host to all the selected agents listed on the screen, but only enabling PI to the first selected agent. To enable SQL PI on the remaining agents, check box the agent, and click Enable SQL PI. Click Apply to accept the highlighted host. Changing the SQL repository in this step will overwrite the original repository selection for the agents, and which is an option if that is the desire. Once the verification is done, The SQL PI indicator is active for the agent. Click Save Changes, and the commenting dialog box pops up with a section to add comments about the installation. Consult the little i for more information on where to locate the comments after the set up has completed. Also, there's an option to not show this pop up again. Click OK. The configuration starts within the process, setting up the PI repository and applying the modified settings to the Selected Agent. SQL PI is now active on the selected agent while listing its PI repository hosts. The PI feature is also reflected on the databases' dashboards. Under Monitoring, Powered by should illuminate the green SQL PI indicator. The agents, since now containing the SQL PI add-on, will also be referenced in the databases' SQL PI dashboards. To learn more Foglight for SQL Server, visit software.dell.com/product/foglight-for-sql-server. For more video tutorials, visit DellSoftware.com/support.