Foglight for SQL Server

Monitoramento de banco de dados escalável, baseado na web, 24 horasx7 dias na semana

With its non-stop data collection and instant metric-sensitive alerts, Foglight for SQL Server® ensures optimal database performance. Orientações especializadas incorporadas, interfaces intuitivas e fluxos de trabalho de fácil uso ajudam você a acelerar o seu trabalho. Além disso, você tem uma análise automatizada de desempenho e uma visão da integridade do banco de dados em nível corporativo. Por isso, é incrivelmente fácil identificar e diagnosticar os servidores e as áreas de recurso onde a degradação do desempenho se originou. Maximizar o desempenho e a disponibilidade do banco de dados com um monitoramento robusto do SQL Server simplesmente não poderia ser mais fácil.

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.

Características

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. Oferece alertas personalizados de alteração.
  • Compare - fornece um atalho para a identificação das causas raiz e sintomas de desvios de desempenho em ambientes de aplicação.
  • 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. Acrescente manualmente instâncias conforme necessário.
  • 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. Obtenha percepção necessária para diagnosticar e solucionar problemas de banco de dados rapidamente. Veja quanto a instância SQL Azure custaria para garantir uma implantação bem-sucedida. Monitore e administre com facilidade o desempenho do Azure.

Requisitos de 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

Vídeos

Capturas de tela

Navegue pelas telas

Navegue pelo Foglight for SQL Server

Nº de capturas de tela: 8

Visão global

Visão global

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

Visão geral da página inicial.

Visão geral da página inicial.

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

Alarmes

Alarmes

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.