|
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 reorganization of databases, tablespaces, and data files with Space Manager with LiveReorg.
|
|
Foglight Database Monitoring Suite
Provides unobtrusive, unattended 24x7 monitoring of your Oracle databases. Features include:
- A complete picture of database health: Monitors all components of the database, including the server, operating system, and network
- Oracle metrics and alarms: Provides metrics, thresholds, and alerts specifically for Oracle, including cache, communications, files and tablespaces, I/O, server processes, queries, Real Application Clusters (RAC), SGA and internal memory, disk space, transactions, and sessions
- Ease of deployment: Automatically detects databases and deploys monitoring agents; also supports remote agentless monitoring
- 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
- Integrated diagnostics: Provides immediate access to detailed diagnostics from Quest Spotlight on Oracle
|
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 Performance Analysis, Spotlight and SQL Optimizer.
|