Profiling & Performance Tuning for PowerBuilder, Oracle, and SQL Server Code

Slowest Code

Visual Expert helps you to troubleshoot performance issues by listing the slowest objects, methods, events, functions, procedures, etc.

Cumulated Execution Time

From another angle, you can also find the objects with the highest cumulative execution time. Saving µs on frequently used features will make a big difference to your users

Call Graph Execution Time

Start your investigation under the angle of the application feature users complain about:

• Visual Expert displays the chain of calls executed behind a feature.
• It shows the average execution time of each item.
• You can then identify bottlenecks and improve the corresponding objects.

PowerBuilder Profiling ^New

Once a slow object has been identified, launch a profiling session for deeper analysis.

Visual Expert displays the functions and lines of code at the origin of performance problems.

Get Query Execution Plan

Fetch a detailed view of the query execution process within your DB. No need to revisit your DB manager for the execution plan.

Add Missing Indexes

Indexes speed up SQL queries, but poor configuration can degrade performance. Their creation depends on SQL code, which changes as the application evolves. Visual Expert automates this task by analyzing database code and schemas, detecting missing indexes to optimize response times.