Notice: will be retired soon. Please visit our new site at
Your Community
Knowledge Base
We're a wiki, like Wikipedia:
All of the information you see is freely editable by any logged-in user. This site is by the community, for the community.
Visit community »
Quest Community
Connect with experts, discuss the latest issues, help shape the products you care about, and much more!
Join now »

Foglight Performance Analysis for SQL Server

Detailed Wait-Event Analysis and Optimization

Foglight® Performance Analysis for SQL Server lets you see enterprise-level performance at a glance. You can determine the root-cause of performance deviations and identify changes to your SQL Server environment quickly and easily.

A powerful enterprise administration and alerting interface lets you create custom dashboards and reports as well as automate and track performance-tuning and problem-resolution initiatives. Foglight Performance Analysis provides a wealth of information — through context-sensitive advisories and detailed wait-event analysis — at a fraction of the impact of conventional collection methods. Note: The functionality of Foglight Performance Analysis for SQL Server is now included in Foglight for SQL Server.


  • StealthCollect® – Delivers deep SQL-level collection and analysis at a fraction of the overhead of tracing or T-SQL.
  • Context-Sensitive Advisories – Reviews workload data and produces custom reports to maximize performance through built-in analytics and business intelligence.
  • True Time-Sensitive Baselines – Allows you to easily determine out-of-bounds activity with the IntelliProfile® learning baseline algorithm.
  • Historical Lock Analysis – Speeds resolution of SQL Server concurrency issues with historical reviews of blocking-lock scenarios.
  • Statement-Level Wait-Event Analysis – Reveals wait-event data down to the statement level, speeding resolution of resource-related performance problems.
  • Compare – Provides a shortcut for identifying the root causes and symptoms of performance deviations in application environments.
  • Automated Change Tracking – Receive notifications of changes to server, instance, database, and schema environments, as well as application SQL degradations. Offers custom change alerts.
  • Integrated Reporting – Provides targeted, built-in reports. With easy-to-use wizards, you can define, customize, generate, schedule, and deliver reports on system health, performance, trends, changes, and a variety of other topics and data points.
  • Long-Term Performance Repository – Delivers unlimited performance and environmental data storage and dimensional analysis in a relational SQL Server database.

Sys Reqs

System Requirements

Client Requirements 
PlatformPentium III (Pentium IV recommended) or compatible processor
  • Dedicated Client: 512 MB of RAM minimum
  • Shared Client: 1024 MB of RAM minimum
Hard Disk Space450 MB of disk space required for a full installation, which includes 200 MB download of temporary setup files that can be removed at the completion of the installation
Notes: The disk space required may vary based on options selected for installation
Database files extracted from a backup require additional storage space depending on the size of the database
Operating System
  • Windows 2000 (SP3 or later)
  • Windows XP (SP1 and SP2)
  • Windows 2000 (SP3 or later)
  • Vista Business
  • Windows 7
  • Windows 2008 R2 X64
  • Windows 2012
Microsoft Data Access Components (MDAC)Version 2.6 or later installed. To verify the MDAC version installed on your computer, follow the instructions from Microsoft's website:
Citrix Support
  • Platform Level - MetaFrame XP 1.0 Server for Windows.
  • Feature Release - MetaFrame XP 1.0, Feature Release 1 through 4

Server Requirements 
  • Intel X86 machines
  • Intel X64 machines
  • Itanium machines
CPU, Memory, and Hard Disk SpaceAccording to the Hardware requirements document accessible from the Documentation page on the Performance Analysis web site
Operating System
  • Windows 2000
  • Windows 2003 32-bit
  • Windows XP (up through SP2)
  • Windows 2008 R2 X64
  • Windows 2012
PeopleSoft Versions8.0 or later
Performance Repository
  • SQL Server 2008
  • SQL Server 2005
  • SQL Server 2000 SP3a and above
  • SQL Server 2012 64 bit
Microsoft Data Access Components (MDAC)Version 2.6 or later installed. To verify the MDAC version installed on your computer, follow the instructions from Microsoft's web site:

Language Supported:

  • US English


  • Use Case Videos

    See for yourself how Foglight® Performance Analysis takes tuning and troubleshooting to a whole new level when it comes to:

    • Product Architecture
    • Investigating CPU Anomalies
    • Resolve Blocking Lock Activity

    Watch the video »


Performance - SQL

At a glance, get visibility into all the SQL running in your environment to pinpoint troublesome queries and poorly performing applications.

History - Summary

Identify SQL Server instance workload, including information on which resources are being used, information on Windows host health, and baseline indicators to identify if the activity displayed is normal for the time period.

SQL Server History - Breakdown

Provides SQL Trace-like granularity without the associated overhead or impact to the SQL workload.

History Workload Overview

Offers built-in business intelligence without the need to build or maintain data cubes. With correlated baseline information to identify normal instance activity and in-context advisory indicators DBAs can find the root cause of performance issues and resolve them with ease.

PA Workload Real-Time

Gain a deeper understanding of normal utilization levels and baseline ranges to improve alerting and diagnose problems caused by resource deviation. Armed with the immediate knowledge that a system is, or is not, behaving the way it usually does helps prove whether the database is the root cause of a performance issue.