Managing SQL Server Database Systems
Installation Guide
for SQL Server
Foglight
®
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.
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.
If you have any questions regarding your potential use of this material, contact: Quest Software World Headquarters
LEGAL Dept 5 Polaris Way Aliso Viejo, CA 92656 www.quest.com email: [email protected]
Refer to our Web site for regional and international office information.
Trademarks
Quest, Quest Software, the Quest Software logo, AccessManager, ActiveRoles, Aelita, Akonix, Benchmark Factory, Big Brother, BridgeAccess, BridgeAutoEscalate, BridgeSearch, BridgeTrak, BusinessInsight, ChangeAuditor, CI Discovery, Defender, DeployDirector, Desktop Authority, Directory Analyzer, Directory Troubleshooter, DS Analyzer, DS Expert, Foglight, GPOADmin, Help Desk Authority, Imceda, IntelliProfile, InTrust, Invirtus, iToken, JClass, JProbe, LeccoTech, LiteSpeed, LiveReorg, LogADmin, MessageStats, Monosphere, NBSpool, NetBase, NetControl, Npulse, NetPro, PassGo, PerformaSure, Point, Click, Done!, Quest vToolkit, Quest vWorkSpace, ReportADmin, RestoreADmin, ScriptLogic, SelfServiceADmin, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Storage Horizon, Tag and Follow, Toad, T.O.A.D., Toad World, vAutomator, vConverter, vEcoShell, VESI, vFoglight, vPackager, vRanger, vSpotlight, vStream, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, Vizioncore vWorkflow,
WebDefender, Webthority, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks are property of their respective owners.
Third Party Contributions
Foglight contains some third party components. For a complete list, see the License Credits page in Foglight online help.
Installation Guide June 2010 Version 5.5.4.5
Table of Contents
Introduction to this Guide ...5
About Quest Software, Inc. ... 6
Contacting Quest Software... 6
Contacting Quest Support ... 6
Installing Foglight for SQL Server...7
Running the Installation Wizard ...9
Introduction Screen ... 10
Quest Software License Agreement Screen ... 11
Foglight Management Server Installation Screen ... 11
Using an Existing Foglight Management Server ... 12
Installing a New Foglight Management Server... 12
Foglight Database Configuration Screen ... 15
Foglight Management Server Installation Progress Screen ... 17
Management Server Connection Screen ... 20
Foglight Management Server License Screen ... 22
Cartridge Installation Screen ... 23
Installation Completed Screen ... 23
Glossary...25
Introduction to this Guide
The Foglight for SQL Server Installation Guide is a quick guide for the installation and use of Foglight for SQL Server, from the planning stage up to the actual monitoring of database instances.
About Quest Software, Inc.
Now more than ever, organizations need to work smart and improve efficiency. Quest Software creates and supports smart systems management products—helping our customers solve everyday IT challenges faster and easier. Visit www.quest.com for more information.
Contacting Quest Software
Refer to our Web site for regional and international office information.
Contacting Quest Support
Quest Support is available to customers who have a trial version of a Quest product or who have purchased a Quest product and have a valid maintenance contract. Quest Support provides unlimited 24x7 access to SupportLink, our self-service portal. Visit SupportLink at http://support.quest.com.
From SupportLink, you can do the following:
• Retrieve thousands of solutions from our online Knowledgebase • Download the latest releases and service packs
• Create, update and review Support cases
View the Global Support Guide for a detailed explanation of support programs, online services, contact information, policies and procedures. The guide is available at: http:// support.quest.com.
Email [email protected]
Mail Quest Software, Inc.
World Headquarters 5 Polaris Way
Aliso Viejo, CA 92656 USA
1
Installing Foglight for SQL Server
Foglight for SQL Server is Quest Software's powerful diagnostic and problem resolution tool for Microsoft SQL Server databases. This Foglight cartridge delivers a global view that provides a visual instance health check, and enables a drill-down style diagnostic workflow to investigate the performance of monitored SQL Server instances and databases.
Before starting the installation of Foglight for SQL Server, ensure that the following conditions are met:
• Use a supported system and platform
Foglight for SQL Server's system requirements and supported platforms are identical to those of the Foglight Management Server. For details, see the Foglight System Requirements and Platform Support Guide.
• Use a Foglight license that allows installing cartridges
Ensure that the Foglight license used allows cartridge installation, otherwise the installation wizard cannot proceed beyond the Management Server License screen.
As Foglight for SQL Server runs on Foglight Management Server, Foglight Management Server must be installed prior to installing this cartridge. The following requirements are relevant only if you plan to install a new Foglight Management Server:
• A clean computer (without a pre-installed Foglight Management Server or Foglight Agent Manager).
• Available ports, as follows: • Cluster mcast port 45566 • HA JNDI RMI port 1101 • HA JNDI JNP port 1100
• HA JRMP invoker port 4447 • HA pooled invoker port 4446 • HA JNDI UDPGroup port 1102 • HTTP port 8080
• HTTPS SSL port 8443 • JNDI RMI port 1098 • JNDI JNP port 1099 • JRMP invoker port 4444 • ORB (IIOP) 3528
• ORB (IIOP) SSL port 3529 • Sufficient disk space.
• A user with sufficient permissions (administrator privileges). For details, see Foglight Administration and Configuration Guide.
• Use an available external database.
If you plan to install the Foglight Management Server on a database other than the one embedded in the installation package, ensure that the specified database is up and running.
Note For further information about Foglight for SQL Server, please see SupportLink, Quest Support’s website, under https://support.quest.com.
2
Running the Installation Wizard
This chapter lists the steps required for using the installation wizard to install Foglight for SQL Server.
Introduction Screen
The Introduction screen presents the installation process and describes the operations required for either proceeding with the installation or aborting it.
Foglight for SQL Server is a database cartridge, utilizing the Foglight Management Server platform. The Foglight Management Server is used for communication, configuration and storage of data. The installation wizard allows either the installation of a new Foglight Management Server or the use of an existing deployment.
Figure 1
To ensure a smooth and successful installation, verify that your system meets the installation prerequisites, as detailed in the Foglight System Requirements and Platform
Support Guide.
Running the Installation Wizard 11
Quest Software License Agreement Screen
Quest Software License Agreement Screen
The Quest Software License Agreement screen allows for the review of the license agreement and the legal bindings involved in the installation of Foglight for SQL Server.
Figure 2
Read the text carefully. To continue with the installation by accepting the agreement, select the I accept the agreement option and click Next. If you do not accept the agreement, the installation cannot proceed beyond this screen and you have to press
Cancel to exit the installation wizard.
Figure 3
Foglight Management Server Installation Screen
As Foglight for SQL Server runs on Foglight Management Server, the installation of Foglight Management Server must be carried out prior to the installation of Foglight for SQL Server.
The Foglight Management Server installation screen allows you to either specify the installation settings of a new Foglight Management Server, or configure an existing Foglight Management Server installation.
Figure 4
Using an Existing Foglight Management Server
Choosing to use an existing Foglight Management Server installation requires typing the connection details and credentials for the existing installation.
Click Next to proceed to the “Management Server Connection Screen” on page 20, which allows you to type these credentials.
Installing a New Foglight Management Server
Selecting to install a new Foglight Management Server requires typing information in the following fields:
• Foglight Management Server Installer File—specify the location of the
Foglight Management Server installation file. By default, the installation wizard looks for the file under the folder that contains the Foglight for SQL Server installation file.
Running the Installation Wizard 13
Foglight Management Server Installation Screen
• Installation Path—specify the path where installation program extracts the
program files.
• FMS HTTP Port—specify the HTTP port number that is to be used for
connecting to the Foglight Management Server.
Click Next to proceed to the “Foglight Database Configuration Screen” on page 15.
Troubleshooting
Error Message Solution
No installation file was provided. Please specify the location of the Foglight Management Server installation file.
The Foglight Management Server installation file field is blank. Enter the exact location of the installation file in this field, either by clicking
Browse or by typing the path manually.
The installation cannot find the Foglight Management Server installation file in the specified path.
The path specified for the installation file is incorrect.
Specify the path that contains the Foglight Management Server installation file.
The installation cannot find the Foglight Management Server Installation file in the path specified. Please specify a file and not a directory.
The path entered in the Foglight Management Server installation file field does not include the specific name of the installation file.
Enter the exact file name of the installation file, either by clicking Browse or by typing the path manually. Verify that you entered the full path, including the file name (for example:
c:\temp\Foglight-5-5-5-install-windows-ia32.exe) and not only the directory (for
example: c:\temp).
The installation requires ZZ MB of free space while only XX MB is available.
Please free at least YY MB of space.
The directory specified for installing the Foglight Management Server does not contain enough free space. This message indicates that instead of the amount of free space required for the installation (represented by ZZ MB in the Error Message column), only a smaller amount (represented by XX MB) is available.
To proceed with the installation, free up the amount of space indicated in the error message (represented by YY MB) and retry the installation operation.
Running the Installation Wizard 15
Foglight Database Configuration Screen
Foglight Database Configuration Screen
The Foglight Management Server requires a repository database to store and process data. The Foglight Database Configuration screen allows the configuration of either an embedded MySQL database, or an external user-specified database of all available database types (that is: SQL Server, Oracle, or MySQL).
Figure 5
If the Foglight Database Embedded option is selected, Foglight automatically installs the embedded database to configure the database repository.
If you select the Foglight Database External option, type the parameters necessary for connecting to an external database, as detailed in the following table.
Parameter Description
Database Type The requested database type: SQL Server, Oracle or MySQL.
The parameters listed below vary according to the selected database type.
If the SQL Server database type is selected:
SQL Server Host The SQL Server host name (by default: localhost).
SQL Server Port SQL Server port number (by default: 1433). SQL Server User SQL Server user name. Ensure that the user
provided has database administrator privileges. Password Database Administrator password, required for
connecting to the database. Repository Database Foglight repository database name. If the Oracle database type is selected:
Oracle Host The Oracle host name (by default: localhost).
Oracle SID Oracle instance name.
Listener Port Oracle TNS listener port number (by default: 1521).
Oracle User Oracle user name. Ensure that the user provided has database administrator privileges.
Password Database Administrator password, required for connecting to the database.
If the MySQL database type is selected:
Running the Installation Wizard 17
Foglight Management Server Installation Progress Screen
Note Selecting the External option requires following the instructions detailed in the Foglight
Installation and Setup Guide for the appropriate combination of database and platform (for
example: MySQL for Windows).
Note The database administrator credentials are required only for setting up the Foglight repository database and creating a user to access it.
Select the requested option and click Next to proceed.
Foglight Management Server Installation Progress Screen
This screen indicates the progress of the Foglight Management Server installation. Upon successful completion of the installation process, the installation proceeds to the License screen.MySQL Port MySQL port number (by default: 3306). MySQL User MySQL user name. Ensure that the user
provided has database administrator privileges. Password Database Administrator password, required for
connecting to the database. Repository Database Foglight repository database name.
Figure 6
Troubleshooting
Error Message Solution
Failed to install Foglight Management Server. Check the permissions on the installation path of the installed directory.
The logon credentials specified lack administrative privileges for the specified directory. The Foglight Management Server cannot be installed. Provide an alternative logon, ensure that the logon specified is granted administrative privileges, or select an alternative directory to install the Foglight Management Server. For details, see the Foglight System
Running the Installation Wizard 19
Foglight Management Server Installation Progress Screen
Failed to create [filename]. Contact Quest Support and send the following: A screen capture of the exact error message. A zipped support bundle
To create this bundle, compress the installation log folder, LSI_Logs.<Installation full date>, located in the same folder as the installation file.
Foglight Management Server installation failed.
The installation of the Foglight Management Server failed.
Install the Foglight Management Server manually, by browsing to the directory where the standalone installation file is found. For installation instructions, see the Foglight
Installation and Setup Guide for your platform. Connection to Foglight Management
Server failed.
Connection to the Foglight Management Server failed.
Ensure that the Foglight Management Server is up and running, by browsing to the Foglight Management Server URL (http:\\<Host
name>:<http port (default 8080)>, and try to
reconnect. If this message persists, contact Quest Support.
Management Server Connection Screen
The Management Server Connection screen allows for entering all of the parameters required for connecting to the existing Foglight Management Server. After entering all of the requested parameters, click Next to proceed.
Figure 7
Note The Foglight Management Server does not support HTTPS connections.
The connection parameters are detailed in the following table.
Parameter Description
FMS Host The computer that hosts the Foglight Management Server.
FMS HTTP Port The HTTP port used for communicating with the Foglight Management Server.
Running the Installation Wizard 21
Management Server Connection Screen
Specify all of the required details and click Next.
Note Foglight defaults include the default FMS HTTP port 8080, FMS user foglight and FMS password foglight. Existing Foglight installations have different values assigned to the aforementioned defaults. If connecting to an existing Foglight installation, ensure that these parameter values are still valid; if not, enter your custom parameter values.
Troubleshooting
FMS User Name The user name used to log in to the Foglight Management Server.
FMS Password The password used to log in to the Foglight Management Server.
Error Message Solution
Connection to the Foglight Management Server failed.
One or more of the required connection
parameters were not provided, or a parameter as not entered correctly. Verify the connection parameters and click Next.
Foglight Management Server License Screen
The Foglight Management Server requires a valid product license that enables cartridge use.
This screen allows for the installation of a license for Foglight Management Server.
To select the file that contains a product license: 1 Click the button to the right of the field.
2 Browse for the license file.
3 Click Open.
After entering the requested license file, click Next to proceed.
Figure 8
Running the Installation Wizard 23
Cartridge Installation Screen
Troubleshooting
Cartridge Installation Screen
This screen indicates that the installation wizard is installing Foglight for SQL Server. The installation procedure of Foglight for SQL Server also installs the Automatic Discovery Wizard, which Foglight for SQL Server uses for adding databases instances and configuring them to be monitored.
Upon successful completion of the installation process of these components, the wizard proceeds automatically to the last screen, Installation Completed.
Installation Completed Screen
The Installation Completed screen indicates that the installation of Foglight for SQL Server has completed successfully.
Error Message Solution
License file not found. Either no text was entered, or the text that was entered is not a valid license file name.
The location provided is a directory. Please specify a file.
The location entered did not specify a file, but a directory (for example: c:\temp instead of c:\temp\license.txt).
Enter the entire path, including the license file.
The Foglight Management Server is not licensed for cartridge
installation.
Ensure using a Foglight Management Server with a valid license file, which allows installing cartridges. For details, contact Quest Support.
Figure 9
Click Done to launch the Foglight Management Server. After logging on to the Foglight Management Server (default credentials: Foglight/Foglight), the Foglight for SQL Server Global View appears.
Click the Database Discovery Wizard link to start setting up your monitored environment.
The Automatic Discovery wizard, which was installed as part of this installation package, provides a fast, intuitive, one-time method for adding database instances to your monitored environment.
3
Glossary
Automatic Discovery
Automatic Discovery, carried out via a database discovery wizard, is a one-time, intuitive method for adding and discovering all of the database instances within a user-specified range, and then configuring these instances to be monitored.
Automatic Discovery is enabled in the Foglight for SQL Server and Foglight for Oracle cartridges, whose installation packages include also the Automatic Discovery cartridge.
Cartridge
Cartridges extend the functionality of Foglight and are installed on the Foglight Management Server. A cartridge contains one or more components, such as agents for deployment, communication capabilities, and modifications to the way that data is transformed or handled, as well as rules, reports, and views.
Foglight Agent Manager
The Foglight Agent Manager manages certain types of agents installed on monitored hosts. It provides a centralized communications link between the Foglight Management Server and these agents and manages the agents’ life cycles. The Foglight Agent Manager also provides a number of support services such as deployment, upgrade, and the ability to configure agents.
For further details, see the Foglight Administration and Configuration Guide.
Foglight Client
The Foglight Client manages certain types of agents installed on monitored hosts. It provides a centralized communications link between the Foglight Management Server and these agents and manages the agents’ life cycles. The Foglight Client also provides a number of support services such as installation, upgrade, and the ability to configure agents.
For further details, see the Foglight Administration and Configuration Guide.
Foglight Management Server
The Foglight Management Server is the central component of Foglight. The Management Server receives information from agents and makes it available in the browser interface.
The Foglight database stores all system, application, and performance data. Over time, it becomes an invaluable source of historical information for planning future system capacity requirements and for doing point-in-time analysis. The information in the database can also be made available for use in external systems.
The Management Server performs continuous internal monitoring on itself and other Foglight components, as well as on the Java Virtual Machine (JVM) and the database.
Index 27
Index
A
About
Performance Analysis Agent 7
Architecture Overview
About the Performance Analysis Agent 7
automatic discovery
glossary definition 25
automatic discovery wizard
installed as part of the Foglight for SQL Server installation 23
needed for setting up a monitored environment in Foglight management server 24
C
connection to Foglight Management Server
when installing a new server 12 when using an existing installation 12
F
Foglight agent manager
glossary definition 25
Foglight client
glossary definition 25
Foglight management server
glossary definition 26
G
glossary definitions
automatic discovery 25 cartridge 25
Foglight agent manager 25 Foglight Client 25
Foglight Management Server 26
J
Java Virtual Machine (JVM) 26
L
licensing
Foglight Management Server license 22 Quest Software license agreement 11
P
parameters needed to connect to an existing Foglight management server installation
host 12 HTTP port 12 password 12 user name 12
Performance Analysis Agent
About 7
ports required for a new installation of Foglight man-agement server 7
R
requirements for installing a new Foglight management server
a clean computer 7
a user with sufficient permissions 8 an available external database 8 available ports 7
sufficient disk space 8
S
support 6
T
technical support 6
troubleshooting
Foglight management server installation progress screen 18
Foglight management server installation screen 13 Foglight management server license screen 23 management server connection screen 21
