SAP HANA 2.0 Administration · Monitoring, Alerts & Troubleshooting

Which SQL statement turns the HANA SQL trace ON from the command line (and how do you turn it off)?

Answer locked. Get the free KnowCard app to reveal it — plus spaced-repetition review so it actually sticks.

This is one card from the KnowCard library — thousands more across SAP, Linux, Python and more. In the app you get the answer, AI explanations, and cards that come back right before you would forget them. Free to start on iOS, Android or the web.

More in Monitoring, Alerts & Troubleshooting

In which directory are HANA trace files for the system database located, and where do the tenant databases' trace files live?

What is the name form of a SAP HANA alert trace file, and which parameter limits its size?

You query STATISTICS_SCHEDULE and every row's key is just a bare number, with no hint of what each collector does. How do you find out which collector is which before editing one?

A HANA instance crashed and you grab the crashdump expecting a complete image of memory at the moment of failure. What do you actually get, and why?

A junior admin asks where the 'system views browser' is in HANA cockpit or Studio so they can click through the monitoring views. What do you tell them?

A user reports a performance anomaly from 7 weeks ago and asks you to pull the statistics history for that day. Why might the data already be gone?

Start learning today

Free to start — download the app or use it in your browser.