SAP
C_HANASUP_1 · Question #84
In the Administration Editor of the SAP HANA studio, how can you identify SQL statements with lock contention?
The correct answer is D. Filter on the LOCK_WAIT_COUNT column in the Expensive Statements Trace tab of the Performance tab. See the full explanation below for the reasoning.
Question
In the Administration Editor of the SAP HANA studio, how can you identify SQL statements with lock contention?
Options
- ACheck the Overall Workload report of the System Information tab.
- BFilter on the DURATION_MICROSEC column in the Expensive Statements Trace tab of the Performance tab.
- CCheck the Record Locks report of the System Information tab.
- DFilter on the LOCK_WAIT_COUNT column in the Expensive Statements Trace tab of the Performance tab.
How the community answered
(47 responses)- A9% (4)
- B4% (2)
- C13% (6)
- D74% (35)
Community Discussion
No community discussion yet for this question.