This tutorial helps review and improve the response time of database code (procedures, functions, triggers, queries…).
It is meant for projects using:
VE must access the database to collect performance data: either your Visual Expert instance can directly connect to the database, or an authorized personnel (DBA for instance) will run a Visual Expert utility against the database to collect it.
Please follow the procedure corresponding to your configuration:
Once the performance data is accessible, VE must analyze your code again, to combine performance data and source code.
Then, you will be able to answer the following questions:
Report type | Purpose |
---|---|
Identify slow objects | Find and sort objects by low response time. |
Optimize a slow object | Break down the response time of a slow object into smaller pieces to identify and remove bottlenecks. |
Optimize slow SQLs | List the SQL queries accessing a table. Sort them by response time. Review their execution plan to improve them. |
Optimize a business process | Analyze the chain of calls behind an application feature: identify slow objects affecting the user experience. |
Review production metrics | Identify the largest tables, the most frequently executed objects, the objects frequently referenced by code, etc. |