The supportability tools for SAP HANA offers a consolidated set of tools for performance analysis and troubleshooting.
With a focus on the needs of support engineers, the performance analysis tools provide enhanced analysis options for trace files and runtime dump files, as well as allowing in-depth analysis on extensive datasets.
The supportability tools for SAP HANA is available as an extension for Microsoft Visual Studio Code and includes a range of reports that can be used for online and offline analysis.
Prerequsites
SAP HANA Database Explorer extension will be installed prior to the supportability tools extension installation which enables you to use the online analysis features.
The supportability tools for SAP HANA provides the following major features:
Offline Analysis
Trace Overview
The trace overview provides an overview of the imported traces of full system information dump (FSID) files.
The report evaluates the current system status information from the dump files and provides the traces in a merged form for each component of the database.
Dump File Viewer
The dump viewer lets you analyze dump files to help troubleshoot the causes of error situations.
The dump viewer consists of three tabs, Auto Analysis, Threads and Call Stack, and Statistics Viewer, on which the results of analyzing the FSID (full system information dump) files or runtime dump files appear:
Auto Analysis
The auto analysis report is the most important feature of the dump file viewer. It categorizes the detected issues into one or more of ten different types and provides a type-specific analysis.
Threads and Call Stacks
The threads and call stack report provides information about individual threads and lets you compare the call stacks of a selected thread.
Statistics Viewer
The statistics viewer lets you display the data of the statistics tables associated with the trace files.
Name Server History Trace Viewer
You can use the name server history viewer to visualize the name server load history data as a load graph.
The load graph provides a graphical display of a range of system performance indicators (KPIs), such as CPU, disk, and memory usage.
A series of lines represents various KPIs of the SAP HANA database and indicates their trend now and in the past.
This information can help you identify a performance issue in the database.
Topology Viewer
The topology information contained in a full system information dump (FSID) file can be visualized in a tree-based view.
This can make it easier to read and understand difficult and hierarchical topology data while you are investigating an issue.
Parameter Viewer
The parameter viewer provides a list of system configurations that have been defined within the contents of the imported Full System Information Dump file.
Abstract SQL Plan Viewer
An ASP is an abstraction of a query execution plan in JSON format which is not a complete plan but contains logical plans and physical properties such as join algorithms.
An abstract SQL plan (ASP) can be exported from the SAP HANA database as a JSON file and then imported into the supportability tools for SAP HANA and visualized.
Online Analysis
Statement Overview
The statement overview provides the most relevant and important information about the top SQL statements in the database.
The results of the individual reports are presented in a visualized form, making it easier to identify critical statements and determine the source of a problem.
Starting from the top SQL statements, the reports let you navigate down into the specific statement details.
Plan Trace
The plan trace enables you to collect SQL queries and their execution plans, executed in a given time frame. For each SQL query that has been traced, you can visualize the execution plan for performance analysis using SQL Analyzer for SAP HANA.
Object Dependency
The object dependency viewer provides a visualization of database objects and their object dependency hierarchy, making information otherwise only available in tabular form easier to understand.
The object dependency viewer provides a graph structure showing the object dependency chains of tables, views, and stored procedures.
