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.
