Foglight for SQL Server

Scalable, Web-Based, 24x7 Database Monitoring

With its non-stop data collection and instant metric-sensitive alerts, Foglight® for SQL Server ensures optimal database performance. Built-in expert guidance, intuitive interfaces, and easy-to-follow workflows help you speed through your work. Plus, you get automated performance analysis and an enterprise-level view of database health. So it’s incredibly easy to identify and diagnose the servers and resource areas where poor performance originated. Maximizing database performance and availability with robust SQL Server performance monitoring simply doesn’t get any easier than this.

Features

  • Global View – Get instance alerts to resolve performance issues faster, both for SQL Server and across platforms.
  • 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 built-in links to Foglight Performance Analysis for SQL Server, context-sensitive links to SQLServerPedia, and Quest's SQL Server Community Forum.
  • Custom Performance Counters – Track service-level-specific processes, as if they were metric counters, to proactively handle performance issues.
  • Adaptive Baselines – Track performance using automatic detection and calculation of normal ranges for all metrics, and receive alerts about deviations from normal activity.
  • Automatic Instance Discovery – Deploy Foglight capabilities with automatic instance discovery or specific hosts. Manually add instances as needed.
  • Historical Data – Navigate easily through performance diagnostics and alarm data to resolve recent performance issues from any drill-down screen.
  • Enterprise Configuration Management – Centralize administration and configuration and customize individual connections.
  • Alarm Workflow – Manage and annotate alarms, set up blackouts, and search for past solutions.
  • Easy Integration – Integrate Foglight for SQL Server seamlessly with other end-to-end enterprise monitors.
  • Wait-State Analysis – Diagnose wait statistics to easily determine where waits are occurring and what is causing the event.
  • 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.
  • Drag-and-Drop Reporting – Create custom views and reports using the data collected by Foglight.
  • Foglight for SQL Azure Cartridge – Use this free add-on to view Azure-specific metrics. Gain helpful insight to rapidly diagnose and resolve database issues. See how much a SQL Azure instance would cost and ensure a successful deployment.  Easily monitor and manage Azure performance.

Sys Reqs

System Requirements

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

Videos

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 Page Overview

In a single view, you can see real-time and historical performance at a glance.

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.

Virtual Overhead Metric for VMware ESX

For those running SQL Server in VMWare ESX, get visibility into performance issues related to CPU and memory.

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.