Excluding Expensive Statements of Specific Users from Tracing

In some specific cases, it might be necessary to exclude the expensive statements of a specific user from HANA tracing. For example, the expensive statements reported by the configured BTC user that are used in collector job executions. It is possible to restrict the tracing to specific application usernames for HANA expensive statements.

Proceed as follows to exclude the expensive statements of a specific user from HANA tracing (the username MON_USER is used here as an example):

1. Start transaction DB02.

2. Click Configuration > INI files.

3. Expand the node INIFILE PARAMETER LIST.

4. Navigate to the following path: Global.ini > expensive_statement > application user.

5. Double-click the node Application user.

6. Set the Value field to ,!MON_USER. Use the comma at the beginning, otherwise the value will be removed.

   • You can also use the wildcard * to apply an arbitrary string as well as negate the value by adding an exclamation mark in front of it.

   • You can find additional information about HANA's expensive statement trace setup in SAP Note 2180165.

7. Click Save.

8. Click Confirm.

After performing this setup, the HANA expensive statements for the user MON_USER will no longer appear in the list of detected expensive statements on the HANA system. As a result, they will no longer be reported in the detail table for expensive statements.