Global View – Determine your most critical instance alarms and immediately take action to resolve performance issues, both for SQL Server (physical, virtual, and SQL Azure) and across other database platforms.
Adaptive Baselines – Track performance using automatic detection and calculation of normal ranges for all metrics, and receive alerts about deviations from normal activity.
Accelerate Problem Resolution — Receive only intelligent warning alerts based on deviations from normal activity. Follow built-in workflows that speed time to resolution and take the guesswork out of interpreting raw data. Optimize performance using context-specific expert advisories.
Prevent Problems and Analyze Trends — Discover and correct degrading performance conditions. Identify significant patterns in resource usage.
Validate Performance during Change — Ensure peak performance for your post-change environment and minimize risk when upgrading your database or deploying new applications.
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 context-sensitive links to SQLServerPedia, and Quest's SQL Server Community Forum.
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.
Automatic Instance Discovery – Deploy Foglight capabilities rapidly and painlessly with automatic instance discovery or specific hosts. Manually add instances as needed.
Alarm Workflow – Manage and annotate alarms, set up blackouts, and search for past solutions.
Rich Historical Data – Navigate easily through performance diagnostics and alarm data to resolve recent performance issues from any drill-down screen.
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.
Wait-State Analysis – Diagnose wait statistics to easily determine where waits are occurring and what is causing the event.
StealthCollect® – Delivers deep Transact-SQL-level collection and analysis at a fraction of the overhead of running a trace or executing direct T-SQL against production.
Performance Advisories – Reviews workload data and produces custom reports to maximize performance through built-in analytics and business intelligence.
QuickCompare – Provides a shortcut for identifying the root causes and symptoms of performance deviations in application environments.
Long-Term Performance Repository – Delivers unlimited performance and environmental data storage and dimensional analysis in an Oracle database.
Automated Change Tracking – Identifies and sends notifications of changes to server, instance, database, schema environments, and application SQL degradations.
Easy Integration – Integrate Foglight Performance Suite for SQL Server seamlessly with other end-to-end enterprise monitors.