-
Titre
Tune SQL button is not responding in the Foglight console in the SQL PI page -
Description
When clicking Tune SQL button from the Workload dashboard under Workload related Metrics for a SQL Statement, a file is downloaded Into the web browser. -
Cause
The SQL Tuning button launches SQL Optimizer using a Windows file association. SQL Optimizer is standalone application that is licensed separate from Foglight and needs to be installed in order to Tune SQLs. -
Résolution
SQL Optimizer for SQL Server or Oracle should be installed on the same PC where the user is accessing the Foglight console.
RESOLUTION 1
In Windows, associate the .quessqloptimizer_ss file extension with C:\Program Files (x86)\Common Files\Quest Shared\Quest SQL Optimizer Shared\OptimizerLauncher.exe
In Windows, associate the .quessqloptimizer_ora file extension with (32-bit) C:\Program Files (x86)\Common Files\Quest Shared\Quest SQL Optimizer Shared\OraOptimizerLauncher.exe or (64-bit) C:\Program Files\Common Files\Quest Shared\Quest SQL Optimizer Shared\OraOptimizerLauncher.exe
RESOLUTION 2
Open for SQL Optimizer for SQL Server or SQL Optimizer for Oracle (respectively)
Import the file into SQL Optimizer by navigating in the product to the web browser download folder.