Foglight for SQL Server

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

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.5.2 are shown below:

Supported Web Browsers

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

Language Supported:

• US English

• Cross-Platform Database Performance Monitoring with Foglight for Databases
  See how easy multi-platform database management is with Foglight.
  Watch the video »

• Product Demo
  Foglight for SQL Server Product Demo  
  Watch the video »