Review production metrics and statistics
Visual Expert collects and presents certain information about the code and database in production, which can help optimize performance.
Visual Expert can answer the following questions:
Largest tables (by Row Count)
This feature is available when you select the root of the Tables in the treeview.
It sorts tables by number of records, as shown below.
The result displays the number of records besides each table - the largest tables are listed first.
You can limit the number of tables by using the following parameter:
The above configuration will list the 10 tables with the largest number of records (see result below).
Largest tables (by volume of data)
This feature is available when you select the root of the Tables in the treeview. It sorts tables by volume of data.
The result shows the table size in MBs beside each table, as shown below.
You can adjust the number of tables displayed with the following parameter:
The above configuration will list the 10 largest tables of the database (see result below).
Most Frequently Executed objects
Visual Expert can identify the most frequently executed objects in the database.
Should you engage in an optimization process, you may want to prioritize these objects, since they are executed more frequently than others.
This feature is available in the treeview, after selecting the root of procedures, functions and triggers:
You can adjust the number objects displayed with the following parameter:
The example above lists the five most frequently executed procedures (see result below).
Most Referenced Objects
Visual Expert can identify the objects that are most frequently called/referenced by other objects.
This feature is available in the treeview, after selecting the root of tables, functions, procedures, triggers and synonyms:
You can check out the complete list of references for a given object: simply select this object in the result and click on “Impact Analysis” in the navigation bar.
In the above example, the table “ProductCategory” is referenced by 3 other objects
You can adjust the number of objects listed by using the following parameter:
The above configuration would display the 5 most referenced functions (see result below).
