Chat now with support
Chat with Support

SQL Optimizer for SQL Server 11.0 - Installation Guide

Installation

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.

Memory

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 8.1 Enterprise (with Update) (32-bit or 64-bit)

Windows 10 (32-bit or 64-bit)

Windows 11 (32-bit or 64-bit)

Windows Server 2008 R2

Windows Server 2012

Windows Server 2012 R2 (with Update)

Windows Server 2016

Windows Server 2022

.NET Framework

Microsoft® .NET Framework 4.7.2

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

Browser Microsoft Internet Explorer 6.0 or later
Database Server

SQL Server® 2008, 2012, 2014, 2016, 2017, 2019, 2022

SQL Server 2008 Express

Note: SQL Server Compact edition is NOT supported.

Cloud Database Service

Microsoft SQL Azure™ Database: Azure SQL Single Database, Azure Elastic Database Pools, and Azure SQL Managed Instance

Limitation: It does not support Find SQL and Optimize Index features.

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