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.
2. Sort functions and procedures by "Total Execution Time":Average execution time × Number of executions over a period
3. Analyze the performance of a chain of callsReview the performance of objects calling each others in your applications.
Improve the response time of a business process.
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: