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 Number of Rows

Sort tables by size, depending on their number of records, as shown below.
Follow this tutorial to apply it to your code.

Table Row Count Macro in Visual Expert

Largest Tables by Size (Volume of Data)

Sort tables by size, depending on their volume of data.
The result shows the size in MBs beside each table, as shown below.
Follow this tutorial to apply it to your code.

identifying tables which occupy large amounts of memory

Most Frequently Executed Objects

Identify the most frequently executed objects in your database.
Should you engage in an optimization process, you may want to prioritize these objects, since they are executed more frequently than others.
Follow this tutorial to apply it to your code.

identify the objects which are most frequently executed in the database

Most Referenced Objects

Identify the objects that are most frequently used/referenced by code.
Follow this tutorial to apply it to your code.

identify the objects which have higher impacts in the project

See Also:

Visual Expert 2021, Code Review, Code Metrics