HANAPerformanceMCP

Use HANAPerformanceMCP to inspect the execution plan, execution stats, and resource usage for this SAP HANA SQL. Identify the main bottlenecks behind the slow query and provide 3 optimization recommendations: SELECT * FROM SALES_ORDERS WHERE CUSTOMER_ID = 'C1024' AND ORDER_DATE >= '2024-01-01';

Returns plan analysis, performance bottlenecks, and actionable indexing or query rewrite suggestions.

Using HANAPerformanceMCP, review current SAP HANA memory usage. Identify the top statements, sessions, or components consuming memory, then summarize likely causes and recommended actions.

Outputs a memory hotspot list, likely sources of abnormal usage, and optimization or cleanup recommendations.

Use HANAPerformanceMCP to summarize key SAP HANA performance data from the last 24 hours, including high-latency queries, execution failure statistics, and memory fluctuations, then create a diagnostic summary for the engineering team.

Generates a team-ready performance summary with key issues, impact scope, and next investigation steps.