Quest Software announced the addition of predictive diagnostics to its Spotlight on Oracle® product, which thousands of customers use to find and fix database performance bottlenecks in real time. The new predictive capabilities extend Spotlight's value and allow users to predict the future performance of SQL statements. It determines which statements will have the most performance degradation given trends in execution rates and overall database load. Spotlight reports the anticipated growth in resource consumption and the percentage of the total load a particular statement will consume. By finding problematic SQL statements before performance is impacted, corrective actions can be taken without disrupting end users and organizations can more effectively meet end user Service Level Agreements (SLAs). Spotlight on Oracle also has expanded diagnostic capabilities for Oracle Real Application Cluster (RAC) environments. Increasingly, organizations running RAC use services to define and control how workload is distributed across the cluster. With new RAC service diagnostics in Spotlight, DBAs can clearly see how each service is distributed across the cluster's nodes and what resources are being consumed on each node by the various services. For more information about Spotlight on Oracle, including a technical brief and white paper on predictive diagnostics, please visit www.quest.com/spotlight-on-oracle.

Related Items:

---

Be first to comment this article

Only registered users can write comments.
Please login or register.