Connect SQL Server for performance data

  1. Create a new Visual Expert project with SQL server code.
  2. Select your code from the database - NOT folders/files.

Connect SQL Server for performance data

Which database will you analyze?

The choice of the database analyzed will determine from where you will collect performance statistics. Ideally, you would analyze a production database. If you don’t have the proper access rights for production, then a test or development database might work, as long as it is enough used to generate relevant performance statistics.

  • Specify and test your database connection.
  • Start the code analysis.
  • Activate the code performance features.

When the analysis is completed, open the tab "Performance" in the Ribbon menu and click on "Activate".

Connect SQL Server for performance data

This will start generating automatically some performance statistics when your code is executed.

After clicking on "Activate":

  • Visual Expert will check it has the necessary access rights for your database
  • Attempt to create a performance event session in your SQL Server database
  • Display a message if an issue is detected.

Please note, this feature is only available for:

  • SQL Server 2012 and higher.
  • Visual Expert projects reading DB code from a database, not from files.

Alternatively, You may also Activate/Deactivate and see the details of the performance event session by opening "Performance Settings".

Connect SQL Server for performance data

  • From this time on, each time a new code analysis will start, Visual Expert will collect the latest performance statistics available, and combine them with the analysis of your code. Please note that if you just activated this feature, you may need to wait for enough code to be executed, before getting relevant statistics.
  • You can stop collecting execution statistics anytime:
    Simply open the performance tab and click on "Deactivate"