Chat now with support
Chat with Support

SQL Optimizer for SQL Server 10.1 - Installation Guide


System Requirements

Before installing SQL Optimizer for SQL Server®, review this section to ensure required privileges are set and system requirements are met.

Hardware Requirements

Component Requirement
Processor 600 MHz minimum, 1 GHz recommended
Disk Space

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:

  • Applications that are running on your system.

  • Size and complexity of the database.
  • Amount of database activity.
  • Number of concurrent users accessing the database.

Software Requirements

Component Requirement
Operating System

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

.NET Framework

Microsoft® .NET Framework 4.0

Note: The .NET Framework Client Profile is not supported.

Browser Microsoft Internet Explorer 6.0 or later
Database Server

SQL Server® 2005, 2008, 2012, 2014, 2016, 2017

  • SQL Optimizer has been tested against SQL Server 2017 running on Windows or Linux.

SQL Server 2005 Express

SQL Server 2008 Express

Note: SQL Server Compact edition is NOT supported.

Cloud Database Service Microsoft SQL Azure™ Database

Virtualization Support

Before installing SQL Optimizer, review the following for virtualization support:

Application Virtualization

SQL Optimizer has been tested with the following:

  • Citrix® XenApp™ 5.0 on Windows Server 2003 (Service Pack 2) using the Citrix Presentation Server Clients 4.0
  • Citrix XenApp 6.5 on Windows Server 2008 R2

Note: SQL Optimizer may work in virtualization environments other than the ones in which it was tested.

Install or Upgrade SQL Optimizer

To install or upgrade SQL Optimizer

  1. Run the SQL Optimizer installation program.

  2. 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.


Install SQL Optimizer Silently

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

  • Execute the following command:

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

  • Execute the following command:

msiexec /i "path to msi file\QuestSQLOptimizerForSQLServer_version.msi" /qn INSTALLDIR="InstallDir"

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating