Foglight for SQL Server

Monitoraggio di database 24x7, scalabile, basato sul web

With its non-stop data collection and instant metric-sensitive alerts, Foglight for SQL Server® ensures optimal database performance. L'assistenza di esperti integrata, interfacce intuitive e flussi di lavoro lineari aiutano a velocizzare il lavoro. Inoltre fornisce un'analisi automatizzata delle prestazioni e una panoramica a livello di organizzazione dello stato di salute dei database. Ciò rende incredibilmente facile identificare e diagnosticare i server e le aree di risorsa che causano le scarse prestazioni. Aumentare le prestazioni e la disponibilità dei database con un solido monitoraggio delle prestazioni di SQL Server non è mai stato così facile.

Foglight for SQL Server now features in-depth SQL workload analysis functionality, called SQL Performance Investigator (SQL-PI). SQL-PI offers a highly scalable, easily configurable SQL workload analytics engine that provides deep SQL workload data collection and investigation. This not only includes baselines, lock analysis, change tracking and multidimensional drilldowns, but also historical session data investigations, all accessible through a high-performance web-based UI.

Caratteristiche

SQL Performance Investigator:

  • Multidimensional SQL workload drilldowns – Investigate database workload by drilling into the datacube; easily drill down across every dimension of your data, such as users, programs, SQL or sessions.
  • Historical lock analysis – Speeds resolution of SQL Server concurrency issues with historical reviews of blocking-lock scenarios. The lock analysis is part of the dimensional drilldown workflow, which greatly simplifies your lock investigations.
  • Automated change tracking – Receive notifications of changes to server, instance, database and schema environments, as well as application SQL degradations. Offre avvisi di modifica personalizzati.
  • Confronti - Fornisce una scorciatoia per l'identificazione delle cause e dei sintomi delle deviazioni prestazionali negli ambienti applicativi.
  • Statement-level wait-event analysis – Reveals wait-event data down to the statement level, speeding resolution of resource-related performance problems.

Global view – Offers a comprehensive overview of all your databases in one dashboard. In a single click, you can access detailed insight into one specific database.

  • Download-and-go architecture – Ensures a fast and easy installation process, so you can start monitoring your databases within minutes. Foglight for SQL Server also seamlessly integrates with other end-to-end enterprise monitors.
  • 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.
  • Built-in intelligence – Understand the health and activity of your SQL Server enterprise with management and performance views and pop-up advice with correlated workflows.
  • 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.
  • Virtual and physical host monitoring – Get the relevant OS metrics for your SQL Servers, whether it is running in a virtual or physical environment.
  • Automatic instance discovery – Deploy Foglight capabilities with automatic instance discovery or specific hosts. Se necessario, aggiungi istanze manualmente.
  • Historical data – Navigate easily through performance diagnostics and alarm data to resolve recent performance issues from any drilldown screen.
  • Enterprise configuration management – Offers centralized administration and configuration as well as the ability to customize individual connections.
  • Alarm workflow – Manage and annotate alarms, set up blackouts and search for past solutions.
  • 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. Usufruisci di una visuale approfondita per diagnosticare e risolvere rapidamente i problemi di database. Scopri il costo di un'istanza SQL Azure e assicurati una distribuzione di successo. Monitora e gestisci facilmente le prestazioni di Azur.

Requisiti di sistema

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 Web Browsers

The Foglight user interface works with standards-compliant web browsers. The following table lists the web browsers that have been tested and validated for use with this release of Foglight.

Browser Type/versionValidated on
Internet Explorer® 8, 9, and 10 (desktop environments only)Latest patch update available at April 2014
Internet Explorer 11 (desktop and touch environments)Latest patch update available at April 2014
Firefox® ESR24.4.0esr
Firefox28.0
Safari® (Mac® OS X Lion or Mountain Lion)6.1.3
Safari(Mac OS X Mavericks)7.0.3
Safari(iOS for iPad)7.0.4
Chrome®33.0.1750.152


Supported Platforms

Operating SystemSQL Server Version
Windows® 2003 (32-bit)SQL 2005, SQL 2008, SQL 2008R2
Windows 2008 (32-bit)SQL 2005, SQL 2008, SQL 2008R2, SQL 2012
Windows 2003 (64-bit)SQL 2005, SQL 2008, SQL 2008R2
Windows 2008 (64-bit)SQL 2005, SQL 2008, SQL 2008R2
Windows 2008R2 (64-bit)SQL 2005, SQL 2008, SQL 2008R2, SQL 2012, SQL 2014
Windows 2012 (64-bit)SQL 2005, SQL 2008, SQL 2008R2, SQL 2012, SQL 2014
Windows 2012R2 (64-bit)SQL 2008, SQL 2008R2, SQL 2012, SQL 2014
Windows 7 (64-bit)SQL 2008, SQL 2008R2, SQL 2012, SQL 2014
Windows 8 (64-bit)SQL 2008, SQL 2008R2, SQL 2012, SQL 2014

Language Supported:

  • US English

Video

Screenshot

Visione complessiva

Visione complessiva

See the health and performance of all your database servers in a single view.

Panoramica Home Page

Panoramica Home Page

View instance, historical performance, real-time data, CPU, memory and VM metrics.

Allarmi

Allarmi

See history of agent status alarms and identify recurring performance issues.

SQL-PI: top databases

SQL-PI: top databases

View database workload and drill down to investigate issues from any angle.

SQL-PI: top SQL

SQL-PI: top SQL

Investigate workload by drilling into top SQL then go deeper into data.

SQL-PI: locked objects

SQL-PI: locked objects

Quickly find the cause of database locking and see who it’s impacting.

SQL-PI: compare

SQL-PI: compare

Comparison reports reveal degradation and changes in performance.

VMware ESX metrics

VMware ESX metrics

View data on your virtual environment and storage to resolve issues.