Quest SQL Optimizer 6.5. for SQL Server. Installation Guide

6.5

Installation Guide

Quest

®

_{SQL Optimizer}

© 2008 Quest Software, Inc. ALL RIGHTS RESERVED.

This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

If you have any questions regarding your potential use of this material, please contact: Quest Software World Headquarters

LEGAL Dept 5 Polaris Way Aliso Viejo, CA 92656 Web site: www.quest.com

Email:[email protected]

Phone: 949-754-8000

Refer to our website for regional and international office information.

Disclaimer:The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.

Trademarks

Quest, Quest Software, the Quest Software logo, Benchmark Factory, LECCOTech, Quest Central, Spotlight, SQLab, Toad, T.O.A.D., and Toad World are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

Third Party Contributions

This product includes software developed by RSA encryption logic from http://www.crypto-central.com/, DPAPI from

http://msdn2.microsoft.com/en-us/library/ms995355.aspx and TDCP_Rijndael from http://www.scramdisk.clara.net, Quest SQL Optimizer 6.5 for SQL Server

Table of Contents

Preface ...iv

About This Guide...v

Additional Information ...v

Online Help...v

Release Notes ...v

About Quest Software, Inc. ...v

Accessibility ...vi

Contact Quest Software ...vi

Contact Quest Support ...vi

Installation ...1

Installation Requirements... 2

.NET Framework ... 2

Privileges Required for Installation ... 2

Hardware Requirements... 3

Software Requirements ... 3

Install Quest SQL Optimizer for SQL Server ... 4

Upgrade Quest SQL Optimizer for SQL Server ... 4

Uninstall Quest SQL Optimizer for SQL Server ... 4

Register Quest SQL Optimizer for SQL Server ... 5

Configuration...6

Access Quest SQL Optimizer for SQL Server... 7

... 7

Preface

Contents

Quest SQL Optimizer for SQL Server Preface v

Installation Guide

About This Guide

This guide describes how to install Quest SQL Optimizer for SQL Server.

Additional Information

In addition to this guide, there are a number of options available for quickly finding the information you need.

Online Help

To access the release notes, select Start | All Programs | Quest Software | Quest SQL

Optimizer for SQL Server| Documentation | Help, or from within the programs,

select Help | Help.

Release Notes

To access the release notes, select Start | All Programs | Quest Software | Quest SQL

Optimizer for SQL Server| Documentation | Release Notes.

About Quest Software, Inc.

Quest SQL Optimizer for SQL Server Preface vi

Installation Guide

Accessibility

Quest Software is committed to providing products and solutions that are accessible to all people regardless of their capabilities. Section 508 compliance details are available by product in the Voluntary Product Accessibility Templates (VPATs) published on our web site at: http://quest.com/public-sector/section508.asp.

Contact Quest Software

Please refer to our web site for regional and international office information.

Contact Quest Support

Quest Support is available to customers who have purchased a commercial version and have a valid maintenance contract or who have a trial version of Quest software. Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at: http://support.quest.com

With SupportLink, you can do the following:

• Quickly find thousands of solutions (Knowledgebase articles/documents). • Download patches and upgrades.

• Seek help from a Support engineer.

• Log and update your case, and check its status.

Phone 949.754.8000 (United States and Canada) Email [email protected]

Mail Quest Software, Inc. World Headquarters 5 Polaris Way

Aliso Viejo, CA 92656 USA

Quest SQL Optimizer for SQL Server Preface vii

Installation Guide

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures. The guide is available at:

1

Installation

Contents

Installation Requirements

Quest SQL Optimizer for SQL Server Chapter 1 2

Installation Guide Installation

Installation Requirements

Before beginning installation, review this section to ensure required privileges are set and system requirements are met.

.NET Framework

Before you can install Quest SQL Optimizer for SQL Server you must have .NET Framework 2.0. or later installed. Both the installation program and Quest SQL Optimizer for SQL Server require .NET Framework to run. You can download the installation program, dotnetfx.exe, from the following website:

http://msdn2.microsoft.com/en-us/netframework/aa731542.aspx

Privileges Required for Installation

Quest SQL Optimizer for SQL Server Chapter 1 3

Installation Guide Installation

Hardware Requirements

Software Requirements

Component Requirement

Processor Pentium III 500 MHZ minimum Disk Space 33 MB of disk space for installation

Note The disk space required may vary based on options selected for installation.

Memory 512 MB of RAM minimum

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.

Monitor SVGA with a minimum resolution of 800x600, 1024x768 recommended

Component Requirement

Operating System Microsoft® Windows® 2000, 2003, XP Professional, Vista Browser Microsoft Internet Explorer 6.0 or later

PDF Viewer Adobe® Acrobat® Reader 5.0 or later (for viewing the Installation Guide)

Database Client PC client connection to SQL Server via Windows

authentication or DB-Library (SQL Server Authentication) Database Server Microsoft SQL Server 7, 2000, 2005, or 2008

Quest SQL Optimizer for SQL Server Chapter 1 4

Installation Guide Installation

Install Quest SQL Optimizer for SQL Server

To install Quest SQL Optimizer for SQL Server

1 Run the Quest SQL Optimizer for SQL Server installation program from the CD or the download file.

2 In the Welcome screen, click Next.

3 In the License Agreement window, review the license agreement.

4 Accept the license and click Next.

5 In the Install Location window, review the default installation directory and change if desired. Click Next.

6 In the Select the Products to Install window, select Quest SQL Optimizer for SQL

Server. Click Next.

7 In the Summary and Confirmation window, click Next.

8 When the installation completes, click Finish.

The production version, the trial version, and the beta version of Quest SQL Optimizer are installed independent of each other. Therefore, you can install or uninstall one without effect the other.

Upgrade Quest SQL Optimizer for SQL Server

Uninstall Quest SQL Optimizer for SQL Server

To uninstall SQL Optimizer using the Quest Installer

1 Select Start | All Programs | Quest Software | Quest Installer |Quest Installer.

2 On the Quest Installer Welcome page, select Uninstall a Product, then click

Next.

Quest SQL Optimizer for SQL Server Chapter 1 5

Installation Guide Installation

4 Confirm that you want to remove SQL Optimizer, then click Uninstall.

5 After the Quest Installer has completed uninstalling SQL Tuning, click Finish.

Register Quest SQL Optimizer for SQL Server

To register the trial or production key

1 In Quest SQL Optimizer for SQL Server, select Help | Register.

2 Enter your Authorization key.

3 If it is a Production key, enter your site message.

2

Configuration

Contents

Quest SQL Optimizer for SQL Server Chapter 2 7

Installation Guide Configuration

Access Quest SQL Optimizer for SQL Server

To run Quest SQL Optimizer for SQL Server, select Start | All Programs | Quest

Index

Symbols

Miscellaneous

A

C

H

I

roles and privileges required 2