Before installing SQL Optimizer for SQL Server®, review this section to ensure required privileges are set and system requirements are met.
|Processor||600 MHz minimum, 1 GHz recommended|
70 MB of disk space to run SQL Optimizer
Note: This is the disk space required for a full installation, which includes 457 MB download of temporary setup files that can be removed at the completion of the installation.
512 MB of RAM, 1 GB recommended
Note: The memory required may vary based on the following:
Windows® 7 (32-bit or 64-bit)
Windows 8 (32-bit or 64-bit)
Windows 8.1 Enterprise (with Update) (32-bit or 64-bit)
Windows 10 (32-bit or 64-bit)
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012 R2 (with Update)
Windows Server 2016
Microsoft® .NET Framework 4.0
Note: The .NET Framework Client Profile is not supported.
|Browser||Microsoft Internet Explorer 6.0 or later|
SQL Server® 2005, 2008, 2012, 2014, 2016, 2017, 2019
SQL Server 2005 Express
SQL Server 2008 Express
Note: SQL Server Compact edition is NOT supported.
|Cloud Database Service||Microsoft SQL Azure™ Database|
Before installing SQL Optimizer, review the following for virtualization support:
SQL Optimizer has been tested with the following:
Note:SQL Optimizer may work in virtualization environments other than the ones in which it was tested.
To install or upgrade SQL Optimizer
Run the SQL Optimizer installation program.
Complete the wizard.
The production, trial, and the beta version of SQL Optimizer are installed independently. You can install or uninstall one without affecting the other.
This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To perform a silent installation of SQL Optimizer
msiexec /i "path to msi file\QuestSQLOptimizerForSQLServer_version.msi" /qn
Note: The following command line options are used:
Command-Line Option Definition /i installs a product /qn Sets user interface to No UI
To perform a silent installation of SQL Optimizer in a directory different from the default product directory
msiexec /i "path to msi file\QuestSQLOptimizerForSQLServer_version.msi" /qn INSTALLDIR="InstallDir"