Identify Most Frequently Executed Objects in your Database

Visual Expert can identify the most frequently executed objects in the database.
This helps PowerBuilder, Oracle, and SQL Server developers prioritize their work and efficiently optimize their code.

How to find frequently executed objects with Visual Expert?

  1. First, you need to activate performance monitoring features within Visual Expert. (See this tutorial)
  2. Then, run your code analysis again.
  3. This feature will appear in the Performance section of the navigation bar after selecting the root of procedures, functions, or triggers:

find the most frequently executed objects at runtime using Visual Expert

Adjust the number of objects you want to display by clicking the ‘wrench’ icon:

In this example, Visual Expert will display the 5 most frequently executed procedures.

find the most frequently executed objects at runtime using Visual Expert

 

find the most frequently executed objects at runtime using Visual Expert

Read the tutorial on how to optimize code performances for more information.

Visual Expert 2020, PowerBuilder, Oracle, SQL Server