Analyze application workload to optimize performance and CPU usage
With many-thousands of tables exploited by SQL queries, the ability of the performance specialist to effectively tune the application or SQL becomes virtually impossible. Developers and packaged vendors endeavour to provide a reasonable set of indexes for their applications, but optimizing the production often requires alternative indexes and very often far fewer. Such analysis is a time-consuming and daunting task since it requires you to review individual SQL of an application for predicate usage and simultaneously take business priorities into account. Administration and development teams often lack the specific information they require to make such critical decisions.
