How to add the SQL PI Extension to a Foglight SQL Server Agent?
This video is applicable for Foglight 5.7.5 and higher.
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:
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 SQL PI 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 under the SQL PI Repository Host column to attach a repository.
The SQL PI 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
Allow Foglight to allocate more memory to the Java Virtual Machine on the Agent Manager is prompted.
To enable PI on the agents, check box the agent and click enable.
Once the verification is done the SQLPI indicator is active. SQLPI is now active on the selected agents while listing its PI repository hosts
The PI feature is also reflected on the databases dashboards. Under "Agents" the SQL PI indicator should display. The agents since now containing the SQL PI add on will also be referenced in the Databases SQL PI dashboard.
© 2020 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz