With the appearance of Hana 2.0 and the XS Advance component, the development tool also changed from Hana Studio or Eclipse to WEB IDE for Hana.

With this change, the way to run the SQL Analyzer Plan changes from running in Hana Studio to running in Web IDE for Hana; in this post I will tell you how to run it in the Visual Studio Code development tool.

Plan SQL Analyzer File

The first thing we have to do is to obtain the file with the SQL Plan, in our example we will obtain it using a Hana Cloud instance and from the console we will execute a SQL statement, which will allow us to download the file with the plan.

SQL Analyzer File

Visual Studio Code

The next step is to open and analyze the downloaded file with the Visual Studio Code tool, of course we must have it previously installed on our computer, this can be done from the following page.

Visual Studio Code Download

SAP HANA SQL Analyzer Extension

Now we can open the file we have downloaded from Hana and analyze it with the SQL Aanalyzer extension of Visual Studio Code.

SQL Analyzer OverView

SQL Analyzer Plan Graph

Some of the relevant points of the extension are:

Navigation panel

  • Plan graphs.
  • Top 5 dominant operators.
  • Top 10 critical path operators.
  • Last 10 visited.
  • Bookmarks.
  • Exceptions.

Overview

  • Execution summary.
  • Dominant plan operators.
  • Audits lists.
  • Data Usage.
  • Distribution shows.
  • Context.
  • System Information.
  • SQL Performance Recommendations.

Additional information can be found at Help.sap.com SAP Hana SQL Analyzer Visual Studio Code

In the same way that we have opened it with Visual Studio Code, we can also use hana Studio or Eclipse to open and analyze the file with the execution plan.

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment