(DI-2211) How to exclude expensive statements for specific users from tracing

Owned by SNP
Nov 08, 2022
1 min read

In some specific cases, there might be a requirement to exclude expensive statements for a specific user from HANA tracing (e.g., expensive statements reported by configured BTC user, used in collector job executions). There is a possibility to restrict trace to specific application usernames for HANA expensive statements. To exclude expensive statements from HANA tracing for a specific user (e.g., user name ‘MON_USER’), follow these steps:

  1. Execute transaction DB02

  2. Navigate to ‘Configuration → INI files’

  3. Expand the ‘INIFILE PARAMETER LIST’ node

  4. Navigate to the following path: global.ini → expensive statement → application user

  5. Double-click the node ‘application user’

  6. Set the value to ,!MON_USER (use ',' at the beginning otherwise the value will be removed)

    1. You can also use wild cards ('*' for an arbitrary string) and negation ('!' in front of the value)

    2. Additional information about HANA's expensive statement trace setup can be found in SAP Note 2180165.

  7. Save the changed value and confirm this setup

After this setup, the HANA expensive statements for user 'MON_USER' should not occur anymore in the list of detected expensive statements on the HANA system and therefore are not reported in a detail table for expensive statements.