Online SQL profiling

20 Mar 2018

During the session we will focus on correlating information observed in optimizer explain plan, with runtime characteristics of the SQLs running on the system. Will look to share method which will let us identify explain plan operators which are consuming most of the CPU on running SQL.

Uniqueness of the method is related to fact that we analyze SQLs running on the system instead of static analysis before SQL is actually executed.

Having knowledge on on above allows DB administrators / SQL developers to identity bottlenecks in plan execution, and take corrective actions to prevent future issues. Method is especially useful for big plans containing hundreds of operators, where manual analysis is ineffective and time consuming.


Languages :  Polski Session Category :  Kraków 2018 

By continuing to use the site, you agree to the use of cookies. więcej informacji

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.