SQL with high CPU time - Merge Join Cartesian
 Case Study Summary

Merge Join Cartesian in the execution plan is famous for its potential to cause CPU spikes on the database server. The following describes an example case scenario.

The list of steps include:

 Step 1 : Trace the change in event 'CPU time'

 Step 2 : Check top SQL with high CPU time

 Step 3 : Check SQL plan for root cause of CPU usage

Copyright 2011 Actrace. All Rights Reserved.
Home | Product | Case Study | Support | Download | Contact Us