Knowledge quiz

It's time to put what you've learned to the test, get 5 right to pass this unit.

Which SAP HANA monitoring view(s) provide historical performance data to help determine when the performance degradation began?

Choose the correct answer.

M_EXPENSIVE_STATEMENTS, M_OUT_OF_MEMORY_EVENTS, and HOST_SQL_PLAN_CACHE provide historical performance data to pinpoint the onset of performance degradation.

M_DATABASE_REPLICATION_STATUS and M_SYSTEM_MEMORY_USAGE show current system resource utilization, not historical trends.

M_WAITING_EVENTS and M_LOCK_WAITS provide real-time information on wait events, not historical performance degradation.

M_CPU_USAGE and M_DISK_I_O_STATISTICS offer current resource consumption metrics, lacking historical performance context.

How can you confirm a performance fluctuation issue using the M_SQL_PLAN_CACHE view?

Choose the correct answer.

By comparing MIN_EXECUTION_TIME and MAX_EXECUTION_TIME values.

By checking if the query has always been slow.

By analyzing the SQL Plan Cache entry's memory usage.

By reviewing the SQL statement hash value.

What is the first step in identifying SQL performance fluctuation issues in SAP HANA?

Choose the correct answer.

Check the application logic for recent changes.

Enable SQL Trace to capture executed SQL statements.

Analyze the SQL Plan Cache for execution statistics.

Review the SAP HANA Statistics monitoring view.

What are the initial steps to identify performance fluctuation factors in SAP HANA applications?

There are two correct answers.

Check for changes in SQL statements or object definitions.

Immediately dive deep into SAP HANA without preliminary checks.

Compare systems with different performance levels to identify application changes.

Ignore application upgrades and modifications.

What are the benefits of using the HOST_SQL_PLAN_CACHE view in SAP HANA?

There are two correct answers.

Shows current plan cache entries only.

Provides historical execution plan statistics for up to 42 days.

Allows analysis of performance fluctuations over time.

Displays out-of-memory events.

What is the most efficient first step in investigating the root cause of performance degradation in an SAP HANA system after an application upgrade, before detailed SAP HANA performance analysis?

Choose the correct answer.

Immediately restart a complete SAP HANA system to clear any temporary issues.

Analyze the SAP HANA system logs for errors or warnings generated during the upgrade process.

Review the application upgrade's changes to identify application program modifications, database object alterations, or input parameter shifts.

Contact SAP support to request a comprehensive SAP HANA system performance analysis.

Knowledge quiz

Which SAP HANA monitoring view(s) provide historical performance data to help determine when the performance degradation began?

How can you confirm a performance fluctuation issue using the M_SQL_PLAN_CACHE view?

What is the first step in identifying SQL performance fluctuation issues in SAP HANA?

What are the initial steps to identify performance fluctuation factors in SAP HANA applications?

What are the benefits of using the HOST_SQL_PLAN_CACHE view in SAP HANA?

What is the most efficient first step in investigating the root cause of performance degradation in an SAP HANA system after an application upgrade, *before* detailed SAP HANA performance analysis?

What is the most efficient first step in investigating the root cause of performance degradation in an SAP HANA system after an application upgrade, before detailed SAP HANA performance analysis?