How to Upgrade Cartridge for SQL Server to Version 5.7.X and Convert PA integrated agents into the SQLPI Extension
This video is applicable for Foglight 5.6.11, 5.7.1, and 5.7.5
How to Upgrade Cartridge for SQL Server to Version 5.7.X and Convert PA integrated agents into the SQLPI Extension?
Step by step instructions
Once you have extracted the DB_SQL_Server 5.7.x.car file locally to your desktop, access and login to the Foglight console.
To install the cartridge proceed under Dashboards | Cartridges | Cartridge inventory
Click on install cartridge and browse to the directory until the extracted DB_SQL_Server 57xx.car file is located and select it. Click open and install cartridge.
The installation process will initiate. Below left corner shows the upload status. The procedure may take a few minutes to complete. When the operation has finished a successful completion message will popup.
The cartridge has successfully updated superseding the previous version acknowledged by a green check mark next to its corresponding components.
Next we need to upgrade the Foglight agent manager Domain and SQL Server agents. To progress the upgrade click the database dashboard should redirect to the upgrade wizard screen.
Select Foglight for SQL Server cartridge domain to upgrade. What’s new in this version is specified in the proceeding screen, please takes some time to review those and click next.
The following screen shows all the Foglight agent managers associated with SQL Server agents needed for upgrade. Select all if needed, Click on upgrade the Selected Agent managers to initiate the process. The operation shall upgrade the discovered SQL Server agents versions, reflecting the upgrade operation success. Click next
It’s always good practice to validate connectivity to check for any new required permission introduced in the version. Select all and click validate connectivity. Once the status validates successfully with connection verified click next to view newly added and/or removed rules.
Rule Modification Overview lists the SQL rules that have been added, removed or updated in the newer version. Click next to migrate the integrated Foglight PA agents to SQLPI
This function of the wizard will create the SQLPI database in form of Posgres SQL repositories and convert the Foglight SQL Server/ PA integrated agents over to SQL Performance Investigator extension. One or more SQLPI PosgresSQL repositories can be created for SQLPI agents. The PI repository can support up to 200 instances with the proper sizing.
Click Assign to create the PI Repository. Agent managers reporting into the FMS and other Specifications met is candidates for PI Repository hosts. Select a qualified Agent manager and click apply. The process will verify the system requirements, if the agent manager selected fails to meet the requirements another box will pop up indicating with some options. Upon completion the selected Agent Manager host where the PostgresSql database will get created on shall appear under SQLPI Repository.
Click assign to appoint the next agent to a SQLPI repository. There is the option to select a different SQL PI repository host for this agent or choose the same SQLPI repository host as the previous agent. Select the SQLPI repository host and click apply.
After system verification validates the host resources to add this agent, Noticed the Agents now have their SQLPI repository hosts assigned.
Click update to upgrade the instances. The update sets up and configures different components of the SQLPI repository on the assigned hosts. Once the operation is done without complications the upgrade successfully dialogue pops up. The new indicator for PI after the conversion replaces the PA indicator. This enabled PI new indicator reference will also display in databases dashboard replacing the PA indicator. At this point the install and upgrade has been successful.
Click finish will direct to the Databases Dashboard and as you can see the SQL Server agent is upgraded showing the PI indicators. There is also a Databases SQLPI dashboard specific for SQL PI agents.
© 2020 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책