Analyze Code Performance

Updated: The Beta Version is available

Code performance analysis features are now in beta.
Contact us if you want to configure and test it with your code.

VE 2018 brings a new set of features to identify slow pieces of DB code (Oracle or SQL Server) and improve their response times. This article previews some of these features.

  • 1. Sort functions and procedures by "Average Execution Time".

    Identify the slowest code.

    Code Performance Analysis: Sort Functions and Procedures by average execution time
  • 2. Sort functions and procedures by "Total Execution Time":

    Average execution time × Number of executions over a period

    Code Performance Analysis: Sort Functions and Procedures by total execution time
  • 3. Analyze the performance of a chain of calls

    Review the performance of objects calling each others in your applications.
    Improve the response time of a business process.
Execution Time of a chain of calls
  • 4. Drill down in your code to identify performance issues.

    After you identified a slow function, this feature allows to analyze the items composing it, to pinpoint precisely the performance issue:
Drill Down to find performance issues roots
Visual Expert 2018, Oracle, SQL Server, Code Performance