Quest Named a Leader
in Gartner’s 2011
Magic Quadrant for APM

Watch CEO Doug Garn discuss what this
means for Quest and application performance monitoring as a whole. Then read Gartner’s
report for yourself.
Read Report »
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.

  • 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.

System Requirements

Client Requirements 
PlatformPentium III (Pentium IV recommended) or compatible processor
Memory
  • 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
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:
http://support.microsoft.com/kb/301202/en-us.
Citrix Support
  • Platform Level - MetaFrame XP 1.0 Server for Windows.
  • Feature Release - MetaFrame XP 1.0, Feature Release 1 through 4

Server Requirements 
Platform
  • 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
PeopleSoft Versions8.0 or later
Performance Repository
  • SQL Server 2008
  • SQL Server 2005
  • SQL Server 2000 SP3a and above
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:
http://support.microsoft.com/kb/301202/en-us

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 »

Take a tour of Foglight Performance Analysis for SQL Server

Screenshots 1 of 6

Screenshot #2 Screenshot #3 Screenshot #4 Screenshot #5 Screenshot #6

Foglight Performance Analysis for SQL Server

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.
Image 1 of 6 Foglight Performance Analysis for SQL Server

Foglight Performance Analysis for SQL Server

Provides SQL Trace-like granularity without the associated overhead or impact to the SQL workload.
Image 2 of 6 Foglight Performance Analysis for SQL Server

Foglight Performance Analysis for SQL Server

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.
Image 3 of 6 Foglight Performance Analysis for SQL Server

Foglight Performance Analysis for SQL Server

Identify changes observed to the host, instance, database, schema, execution plan and even user-defined changes along an instance timeline to visually indicate how a change has affected instance performance.
Image 4 of 6 Foglight Performance Analysis for SQL Server

Foglight Performance Analysis for SQL Server

Automatically identifies the differences in performance between any monitored data and/or timeframe so DBAs can easily identify how performance differs without a manual investigation.
Image 5 of 6 Foglight Performance Analysis for SQL Server

Foglight Performance Analysis for SQL Server

Allows DBAs to quickly and easily identify how object contention and blocking scenarios are affecting instance health so they can address the most impactful concurrency problems first.
Image 6 of 6 Foglight Performance Analysis for SQL Server

Support Docs, Notes and Guides

Release Notes and User Guides back to top
 

Learn More

Related Products

Support for This Product