Targeted business outcomes
You can use this guide to achieve the following business outcomes with cluster cache management (CCM):
In the event of a failover, recover quickly to help maintain stable and optimal workload performance.
Reduce business losses caused by poor workload performance after a failover.
Help prevent unnecessary I/O costs after a failover.
You can use this guide to achieve the following business outcomes with query plan management (QPM):
Improve plan stability by forcing the optimizer to choose from a small number of approved plans. This prevents the optimizer from selecting a sub-optimal plan for a given SQL statement after system or database changes.
Optimize plans centrally and then distribute them globally.
Determine which indexes aren't being used, and evaluate the effects of adding or removing an index.
Automatically recognize any new minimum-cost plans that the optimizer identifies.
Test new optimizer features with minimal risk because you can decide to accept only the plan changes that improve performance.
