United States - English

Australia - English

Belgium & Luxembourg - English

Latin America - Español

Netherlands - Dutch

New Zealand - English

Russia - Росси́я

Scandinavia - English

South East Asia - English

Spain - Español

United Kingdom - English

Application and Service Technology Platforms		Home > Application and Service Technology Platforms > Features & Benefits of SQL Server Performance Management with Foglight		Print Page		Request a Quote		Email Page

Features and Benefits

SQL Server Performance Management

As the leader in database management, Quest has a whole host of capabilities to ensure the performance and availability of your SQL Server databases. Whether you need robust 24x7 monitoring, diagnostics and analytics to complement your existing monitor, or a complete solution to detect, diagnose, and resolve performance issues, Quest has a solution that’s right for you.

Foglight Database Management Suite

Includes all the capabilities of the Foglight Database Monitoring Suite and the Foglight Database Performance Suite (below).

Also provides additional performance optimization through management of database storage with Capacity Manager for SQL Server and LiteSpeed for SQL Server Enterprise.

Also includes Foglight Business Service Management so you can add a strategic business-oriented perspective to database management.

Foglight Database Monitoring Suite

Provides unobtrusive, unattended 24x7 monitoring of your SQL Server databases. Features include:

A complete picture of database health: Monitors all components of the database, including the server, operating system, and network
SQL Server metrics and alarms: Provides metrics, thresholds, and alerts specifically for SQL Server, including transaction logs, top users, blocked users, error logs, CPU utilization, memory utilization, and cache hit ratio
Holistic view: Correlates database, application, and end-user performance to provide a holistic view of database health
Ease of maintenance: Adaptive architecture eliminates blindspots and streamlines ongoing system maintenance

Foglight Database Performance Suite

Uses highly specialized collection methods to gather extensive high-fidelity data about database activity and analyzes this data to provide powerful insights into database performance. Features include:

Detailed performance metrics: Provides continuous, high-frequency collection of extensive diagnostic data without impacting database performance
True performance baselining: Provides an accurate baseline of database performance, taking into account normal fluctuations (such as end-of-month processing)
Dimensional analysis: Analyzes and correlates performance metrics to identify complex or sporadic performance issues
Change tracking: Isolates problems resulting from changes to configuration parameters, schema, execution plans, etc.
Comparison: Shows performance variations over time and exposes trends that need attention
Advisories: Continuously assesses database health and provides alerts and action plans for corrective action
SQL optimization: Automatically analyzes SQL statements and recommends changes or indexes to improve performance

The Foglight Database Performance Suite consists of Foglight Database Performance Analysis and SQL Tuning.