Documentation

Foglight Performance Analysis for SQL Server

We understand that the process of evaluating a performance management solution can be challenging. Not only can it be difficult to coordinate times for demonstrations, evaluations, and knowledge transfer sessions, but understanding new features, functions and interfaces in a short period of time, especially when business critical work needs to be done, is no trivial matter. The following materials should help you navigate from initial product evaluation and fact gathering, through implementation and product utilization, ensuring that you have all the information.

What is Foglight Performance Analysis for SQL Server, and what does it mean to me?

Introduction to Foglight Performance Analysis for SQL Server: This document provides a concise product overview. Topics include features and functions, product architecture, what the future holds, and what your license of offers in the form of support, upgrades and new releases.

Using Foglight Performance Analysis for SQL Server: This short video introduces the product interface, highlights key capabilities, and illustrates some common use cases for troubleshooting performance bottlenecks in your environment.

What do my infrastructure teams need to know?

Communications Architecture: This document provides a comprehensive overview of the product architecture including port usage, firewall communications, network security, and a detailed diagram of all product communication.

Security and Compliance: This document describes the product’s security features and covers access control, protection of customer data and secure network communication. This document also includes information on compliance with the NIST recommended federal information security standards promulgated under the Federal Information Security Management Act (FISMA).

Limited Permissions Setup: This document reviews the permissions required for product installation, and goes into detail on how user accounts can be modified after initial install to minimize system access.

What does it take to install Foglight Performance Analysis for SQL Server?

Pre-Installation Checklist: This document provides a step-by-step guide to preparing your installation environment (including clustered environments), and provides the order of execution to install the various components.

Middleware Sizing Assistant (must create a SupportLink login): This document is an integral part in planning for the product infrastructure and Quest strongly recommends it be completed in advance of any installation. Completing this document will ensure that the middleware server has sufficient memory and CPU resources to operate correctly.

Agent Installer User Guide: This document provides detail of the product architecture, installation prerequisites, installation, upgrade and uninstall steps and processes, as well as information on how to install into clustered environments and when monitoring ERP systems.

Release Notes: This document is the de facto resource for understanding new product features, known issues, and to identify platform and version support.

Silent Installer User Guide: This document provides an overview and operating instructions for the Silent Installer tool, which allows scripted (batch mode) installations including how to prepare the installation environment and carry out the installation, and describes the common installation scenarios.

Need Help?: Quest has resources available to help you prepare your environment for installation. With very concise offerings and an exceedingly low price point, it’s the help you need at a price you can afford.

After you install

Repository Schema Document (Contact Quest Support): This document highlights the wealth of information stored in the long-term performance repository and provides full schema documentation, object and metadata explanations, and sample queries to help you create your own custom queries and reports.

SQL Server User Community: Discuss your use of the product, ask questions and find answers in the user forums, read technical articles and other documents, and catch up on product use case videos.

QuestKB: Stay up to date on product news, or any Quest database-related information as it happens. Subscribe today and get updates on product news as it happens!

SQLServerPedia: Quest’s wiki for all things SQL Server. Have a question on how to interpret what a product is telling you, or how to deal with a SQL Server issue in your environment? SQLServerPedia is the resource you’ve been looking for!

SupportLink: Quest’s team of expert technical support specialists is always ready to assist you, and you can leverage the wealth of information in their knowledgebase any time.

Need Training?: Quest has resources available to help train your staff on making the most of your investment. With focused offerings at affordable prices, our programs are tailored to fit your needs, your schedule, and your budget.