Various traces are available for obtaining detailed information about the actions of the database system. We can activate and configure traces in the SAP HANA studio on the Trace Configuration tab of the Administration editor.
Prerequisites
To configure traces, you must have the system privilege TRACE ADMIN. To configure the kernel profiler, you must have the SAP_INTERNAL_HANA_SUPPORT standard role.
Below are the traces which we can your for database administration
- Database traces (basic, user, end-to-end)
- SQL trace
- Performance trace
- Expensive statements trace
- Kernel profiler
- Plan traceProcedure1
Results
Data recorded by traces are saved to trace files, which you can view on the Diagnosis Files tab.