Visual Expert allows you to analyze the performance of the database code.
To do this you need to connect to your SQL Server database and enable performance statistics collection.
The choice of the database analyzed will determine from where you will collect performance statistics. Ideally, you would analyze a production database.
If you do not have access rights to the production database, a test or development database may be suitable, provided it is used enough to generate relevant performance statistics.
When the analysis is completed, open the "Performance" tab in the Ribbon menu and click on [Activate].
This will start generating automatically some performance statistics when your code is executed.
After clicking on "Activate":
This feature is available for:
You can also activate/deactivate the feature and check the performance event by opening "Performance Settings".
From this time on, each time a new code analysis will start, Visual Expert will collect the latest performance statistics.
To get a combined analysis of the code and the database performance:
You can stop collecting execution statistics anytime:
Simply open the performance tab and click on [Deactivate].