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.
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.
Plan Trace Viewer
The plan trace viewer provides the list of collected plan traces from the imported plan trace compression(PLT) files.
The viewer provides the overall information of the captured statements and the detailed information of each statement including the SQL text.
In case user has installed the SQL analyzer tool for SAP HANA extension, the statement can be analyzed with the SQL analyzer with its captured PLV.
MDS Trace Validator
The MDS trace validator provides visualization and validation of MDS traces to help support teams analyze trace collection issues. The validator consists of five main sections: File Selection, SQL Comparison, Request/Response Comparison, HAR contents, and MDS Trace contents.
You can validate and compare MDSQueryDisplay JSON files, DatasourceSQL text files, HAR content files, and MDS Trace files to ensure correct trace collection and identify differences between expected and actual SQL execution.
The validator includes features like SQL comment filtering, diff visualization, instance ID validation, and comprehensive request/response analysis with resultset visualization.
MDS ResultSet Viewer
The MDS ResultSet viewer provides comprehensive visualization of MDS ResultSet data, allowing users to analyze response data from MDS traces in detail.
You can load JSON content either by selecting a file or by copying and pasting JSON content directly into the editor. The viewer displays resultset data including Grid, Metadata, Performance, and Messages datasets.
The viewer integrates with the MDS Trace Validator and provides full-screen viewing capabilities for detailed analysis of individual resultsets.
