Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

Execute HANA SQL Trace Analyzer Python Tool

|| 0

Execute HANA SQL Trace Analyzer Python Tool
Stechies

How to execute SAP HANA SQL Trace Analyzer Python tool?

You can call the Python script with different options as listed below:

python sqlTraceAnalyzer.py [-s <split-filename>] [-c <catalog-dir>] [-m <merge-stat-file>] [-u <user>] [-k <top k values to show>] [-disjunct] [-tr] <sqltrace-filename> [<sqldump-file>] [<tables-file>]

With the '-tr' option local temp table names can be replaced by the common placeholder "#<local-temp-table>". This is useful to generate accumulated statistics for statements on generated temp table names that only differ in the generated table name.

Examples:

python sqlTraceAnalyzer.py <sqltracefile>

python sqlTraceAnalyzer.py /usr/sap/<SID>/HDB00/host/trace/sqltrace_host_30003_000.py


Advertisement
Advertisement