Quest Support
  • Global Coverage
  • Highly Skilled Engineers
  • Commitment to Customer Satisfaction
  • Flexible Support Offerings
Learn more »

Foglight Performance Suite for SQL Server

SQL Server Monitoring, Diagnostics, and Advanced Workload Analysis

This complete SQL Server performance management solution constantly monitors the health of your physical and virtual SQL Server environment, accelerates problem resolution, simplifies workload trend analysis, and delivers targeted custom reports – all from an easy-to-use web console. The Foglight Performance Suite enables you to resolve issues before they impact users and makes your job easier by extending the capabilities of basic database monitoring tools. Plus, it greatly reduces the risks associated with database vulnerability, performance bottlenecks, upgrades, patches, and more. With the Foglight Performance Suite, you’ll work smarter, not harder – and maximize your SQL Server database resources.

Features

Global View – Determine your most critical instance alarms and immediately take action to resolve performance issues, both for SQL Server (physical, virtual, and SQL Azure) and across other database platforms.

Adaptive Baselines – Track performance using automatic detection and calculation of normal ranges for all metrics, and receive alerts about deviations from normal activity.

Accelerate Problem Resolution — Receive only intelligent warning alerts based on deviations from normal activity. Follow built-in workflows that speed time to resolution and take the guesswork out of interpreting raw data. Optimize performance using context-specific expert advisories.

Prevent Problems and Analyze Trends — Discover and correct degrading performance conditions. Identify significant patterns in resource usage.

Validate Performance during Change — Ensure peak performance for your post-change environment and minimize risk when upgrading your database or deploying new applications.

Built-In Intelligence – Understand the health and activity of your SQL Server enterprise with management and performance views, pop-up advice with correlated workflows, and context-sensitive links to SQLServerPedia, and Quest's SQL Server Community Forum.

Wizard-Driven Installation – Use a powerful wizard to easily install and configure Foglight as a standalone solution or to add SQL Server monitoring to your existing infrastructure.

Automatic Instance Discovery – Deploy Foglight capabilities rapidly and painlessly with automatic instance discovery or specific hosts. Manually add instances as needed.

Alarm Workflow – Manage and annotate alarms, set up blackouts, and search for past solutions.

Rich Historical Data – Navigate easily through performance diagnostics and alarm data to resolve recent performance issues from any drill-down screen.

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.

Wait-State Analysis – Diagnose wait statistics to easily determine where waits are occurring and what is causing the event.

StealthCollect® – Delivers deep Transact-SQL-level collection and analysis at a fraction of the overhead of running a trace or executing direct T-SQL against production.

Performance Advisories – Reviews workload data and produces custom reports to maximize performance through built-in analytics and business intelligence.

QuickCompare – Provides a shortcut for identifying the root causes and symptoms of performance deviations in application environments.

Long-Term Performance Repository – Delivers unlimited performance and environmental data storage and dimensional analysis in an Oracle database.

Automated Change Tracking – Identifies and sends notifications of changes to server, instance, database, schema environments, and application SQL degradations.

Easy Integration – Integrate Foglight Performance Suite for SQL Server seamlessly with other end-to-end enterprise monitors.

Sys Reqs

System Requirements

Foglight Performance Suite for SQL Server is comprised of Foglight for SQL Server and Foglight Performance Analysis for SQL Server.

Before installing Foglight for SQL Server, ensure that your system meets the hardware and software requirements detailed in Foglight System Requirements and Platform Support Guide. Customers running large deployments (above 50 instances) should consult with the Foglight for SQL Server sizing assistant.

Foglight for SQL Server requires WMI access for monitoring Windows Operating system metrics on the various SQL Server dashboards. Ensure that the WMI and Remote Registry services are started prior to creating the agents and throughout the monitoring process. Firewall usage requires taking further steps to ensure connection to WMI, as detailed in the known issues section under Connection to WMI.

Supported Platforms

The operating system platforms and SQL Server versions supported by the Foglight for SQL Server agent on Foglight 5.5.2 are shown below:

Operating SystemSQL Server Version
Windows 2000, 2003, 2008 (32-bit), 2012SQL 2000, SQL 2005, SQL 2008,SQL 2012
Windows 2000, 2003, 2008 (64-bit Opteron and Xeon), 2012SQL 2000, SQL 2005, SQL 2008,SQL 2012
Windows 2003 (Itanium)SQL 2000, SQL 2005, SQL 2008,SQL 2012

 

Supported Web Browsers

The following table lists the Web browsers that have been tested and validated for use with Foglight 5.6.3.

Browser TypeVersion / Patch Level Validated
Internet Explorer 6 (see “Final Support Notice”)Latest patch update available at February 2012
Internet Explorer 7Latest patch update available at February 2012
Internet Explorer 8Latest patch update available at February 2012
Internet Explorer 9Latest patch update available at February 2012
Firefox 3.63.6.26
Firefox 1010.0.2
Safari 5 (Mac OS X only)5.1.3
Chrome 1717.0.963.46


Language Supported:

  • US English

Screenshots

Global View

See the operational health and performance of all database servers, regardless of platform, from a single view. Gain enterprise-level insight into your database environments. Foglight unifies all your databases in a centralized console to deliver consistent data and reports; this significantly increases administrative efficiency.

Home Pages New-Overview (SQL Server)

Email integration, Help Desk integration for workflow actions.

Real time

Drill into a single SQL Server instance to monitor performance in real time.

Custom Dashboard

Easily create customized dashboards and reports through a simple “drag and drop” interface. Extend visibility of database health and metric data to other areas of the business, including executive management, application development, storage administrators, etc. Most monitoring solutions require end users to view data in a specific, vendor-supplied mechanism. Foglight offers extensive dashboard and report customization that allows each customer to view real-time and historical data according to their unique requirements.

Performance - SQL

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

Alarms

The new Alarms dialogue allows you to see the history of your agent status alarms and drill into details to identify recurring performance issues.

Drilldowns New-Sessions (SQL Server)

Drill into a platform-specific Quick View Card for more detail, without leaving the global summary. Quickly investigate high-level database health, without launching separate, disconnected consoles. Speed problem-resolution time by monitoring and diagnosing issues from a single web-based user interface.

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

New-PA History Workload Overview 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..