Foglight for Cross-Platform Database Environments

Cross-platform database monitoring with one consolidated view

Consolidate and standardize database performance management across diverse database environments.

Ensure consistent service levels across multi-platform database environments, even when you use native or third-party tools. Foglight for Cross-Platform Database Environments enables you to consolidate and standardize database performance management across your diverse environments. Experience deep, complete integration across database platforms that promote collaboration, improve service levels and reduce costs.

Foglight for Cross-Platform Database Environments supports Oracle, SQL Server, DB2, and Sybase databases.

Features

  • Global view – Resolve performance issues across database platforms by determining your most critical problems and taking immediate action.
  • Built-in intelligence – Get integrated management and performance views that allow you to understand your enterprise’s health and activity. Also receive pop-up advice with correlated workflows.
  • Adaptive baselines – Receive alerts about deviations from normal activity, as well as track performance using automatic detection and calculation of normal ranges for all metrics.
  • Automatic instance discovery – Use automatic instance discovery or specific hosts to deploy Foglight capabilities rapidly and painlessly. Manually add instances, as needed.
  • Rich historical data – Resolve performance issues by navigating through diagnostics and alarm data from any drill-down screen.
  • Alarm workflow – Search for past solutions, set up blackouts, and manage and annote your alarms.
  • Easy integration – Integrate your other end-to-end enterprise monitors seamlessly.
  • Wait-state analysis – Determine the location and cause of waits by diagnosing your wait statistics.
  • Wizard-driven installation – Add database monitoring to your existing infrastructure or configure Foglight as a standalone solution with this powerful wizard.
  • Drag-and-drop reporting – Use the data collected by Foglight to develop customized views and reports.

Resources

Screenshots

loading

Foglight for Cross-Platform Databases - Dashboard View (6 Screenshots)

See and assess the health of your entire monitored environment from a single view.

Take a Screenshot Tour
loading

Screenshots by Platform - Foglight for SQL Server (8 Screenshots)

Take a Screenshot Tour
loading

Screenshots by Platform - Foglight for Oracle (5 Screenshots)

Take a Screenshot Tour
loading

Screenshots by Platform - Foglight for DB2 (4 Screenshots)

Take a Screenshot Tour
loading

Screenshots by Platform - Foglight for Sybase (3 Screenshots)

Take a Screenshot Tour

Global View of Cross-Platform Databases

Global View of Cross-Platform Databases

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.

Quick View Drilldowns

Quick View Drilldowns

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.

Intelliprofile Baselines

Intelliprofile Baselines

Gain a deeper understanding of normal utilization levels and baseline ranges to improve alerting and diagnose problems caused by resource deviation. Armed with the immediate knowledge that a system is, or is not, behaving the way it usually does helps prove whether the database is the root cause of a performance issue.

Platform-Specific Drilldowns

Platform-Specific Drilldowns

Utilize deep diagnostic drilldowns from a single web-based interface to troubleshoot performance and availability problems, either in real time or during a historical period. This eliminates the need for separate, disconnected monitoring and diagnosis tools that have different resolution workflows. Foglight ensures a consistent, universal process across all database platforms.

Customizable Dashboards and Reports

Customizable Dashboards and Reports

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.

Scheduled Reporting

Scheduled Reporting

Automate report scheduling and delivery to eliminate time-consuming, repetitive tasks. In any organization, several personas need access to data about database performance and health. With Foglight, these reports can be automated, scheduled, and customized, so DBAs can focus on managing their environments.

Global View

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

Home Page Overview

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

Real time

Real time

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

Custom Dashboard

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

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

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

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)

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.

Global View

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 – Instance View

Home Page – Instance View

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

Custom Dashboard

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, and storage administrators. 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

Performance - SQL

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

Oracle Performance Dimensions

Oracle Performance Dimensions

Evaluate resource consumption of total SQL workload analyzed by multiple dimensions, including specific programs and OS users.

Foglight Home Page View – DB2 Database

Foglight Home Page View – DB2 Database

View the health of your DB2 database environment and drill into performance issues.

Foglight Home Page View – DB2 Instance

Foglight Home Page View – DB2 Instance

Instance view of your DB2 environment shows current activity and performance alarms, allowing you to drill into issues.

Lock Overview – DB2

Lock Overview – DB2

See locking activity with metrics for wait times and average, escalations and locks per application.

Application Overview of Lock Activity – DB2

Application Overview of Lock Activity – DB2

Overview of locks activity broken out by application.

Foglight Home Page View – Sybase Instance

Foglight Home Page View – Sybase Instance

View the health of your Sybase environment and drill into performance issues.

Locks Overview – Sybase Instance

Locks Overview – Sybase Instance

See locking activity for your environment with details for each database.

Wait Events - Sybase

Wait Events - Sybase

See top wait activity with metrics by wait times and waits enqueue, plus top users, sessions and procedures.