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 in your Code?

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:

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.

 

 

SEE ALSO:

• Largest Tables by Rows
• Largest Tables by Volume of Data
• Objects Most Referenced
• Improve the Performance of your DB Code