Quest Software, yesterday 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.
Spotlight on Oracle analyzes SQL performance to determine 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).
“In virtually every organization, the database is core to critical applications, processes and user activities. Therefore, IT must be as proactive as possible when it comes to database performance management,” said Guy Harrison, Oracle expert, Quest Software. “The traditional approach of fixing problems as they occur fails to adequately ensure business service levels.”
No comments:
Post a Comment