Code Analyst

From RapidSQL
Jump to: navigation, search

Go Up to Add-on tools

The Code Analyst is a tool to identify time-consuming lines of code. Code Analyst lets you:

  • Perform detailed response time analysis on the execution of Procedures.
  • Benchmark the execution of one or more procedures or functions to determine exactly what code objects and lines of code are taking the longest to run.
  • Save response time metrics and perform intelligent compares against current execution times so you can determine deviations from previous acceptable response times.
Tip: You can set Code Analyst options in the Code Analyst Options.

Important Notes

  • For DB2, before profiling with Code Analyst, Compile all procedures with the debugging option selected.
  • For Oracle, when using the Oracle Debugger, Compile all procedures with the debugging option selected before profiling with Code Analyst.

Common Tasks