How can you identify SQL statements with lock contention?

In the Administration Editor of the SAP HANA studio, how can you identify SQL statements with lock contention?
A. Check the Overall Workload report of the System Information tab.
B. Filter on the DURATION_MICROSEC column in the Expensive Statements Trace tab of the Performance tab.
C. Check the Record Locks report of the System Information tab.
D. Filter on the LOCK_WAIT_COUNT column in the Expensive Statements Trace tab of the Performance tab.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.