Using the Elastic Compute Node Advisor

Requesting manual recommendations is advantageous for addressing recurring workload peaks. By focusing on similar historical peak periods, the ECN Advisor can efficiently pinpoint workload classes for ECN routing to relieve coordinator workload stress.

To be able to use the ECN Advisor make sure that the following prerequisites are met:

• Your SAP HANA Cloud database instance must include a minimum of five vCPUs.
• At least one workload class should be configured.
• The SAP HANA Cloud Viewer role collection is necessary to access ECN Advisor data on your subaccount.
• The SAP HANA Cloud Administrator role collection is required to configure the ECN Advisor and to request recommendations.

To configure the ECN Advisor perform the following steps:

1. Verify ECN Advisor Activation

   On your instance Overview page, select the Advisors card and ensure the ECN Advisor is activated on the Advisors tab.

   The following demonstration shows how to activate the ECN Advisor from SAP HANA Cloud Central.

   DemoStart Demo
2. Initiate ECN Advisor Recommendation

   Select an ECN Advisor-related row on the Advisors tab to access the ECN Advisor page, then click "Get Recommendation."

3. Establish Time Frame for ECN Analysis

   Choose a timeframe between 30 minutes to 24 hours; ensure it ends at least 20 minutes before initiating the recommendation and falls within the previous 14 days.

   Use the Resource Usage chart to identify recurring peaks, such as every Monday from 8:00 AM to 10:00 AM, and set this range in the Timeframe field. The ECN Advisor will scrutinize coordinator workload during this timeframe. Exceeding thresholds will prompt routing recommendations to an ECN. Your chosen start and end times will dictate ECN addition and deletion respectively.

   Note

   Enable expensive statement tracing during analysis for detailed statement-level assessment. Lacking tracing data, the advisor resorts to WORKLOAD_CLASS_STATISTICS.
4. Adjust ECN Recommendation Thresholds (Optional)

   Modify default thresholds for memory and compute as needed, representing a percentage of your instance’s coordinator capacity.

   Omitting values will default thresholds for memory and compute.

5. Proceed with Get Recommendation

   Post-execution, the ECN Advisor evaluates your workload, if the thresholds are surpassed, a recommendation is generated and the eligible workload classes for ECN processing are identified. Review and apply recommendations as necessary; refer to "Applying ECN Advisor Recommendations" for further guidance.

   The following demonstration shows how to generating an ECN Recommendation from SAP HANA Cloud Central.

   DemoStart Demo

Recommendations encompass ECN additions and workload class routing setups. Optimal implementation adheres to advised processes, though the ECN Advisor doesn't verify proper application.

To be able to implement the ECN Advisor recommendations make sure that the following prerequisites are met:

• An ECN Advisor recommendation must be available for your workload.
• SAP HANA Cloud Viewer role is required for viewing ECN Advisor data on your subaccount.
• The SAP HANA Cloud Instance Administrator role collection is required to manage ECNs in your subaccount.
• The WORKLOAD ADMIN privilege is needed to route workloads to ECNs using workload classes.

Use SAP HANA Cloud Central to perform the following steps:

1. Access Recommendation Details

   Navigate to the Recommendations tab in the ECN Advisor application, selecting the row with the desired recommendation.

   Use the Manage Configuration andWorkload Management applications for implementation guidance.

2. ECN Addition as Advised

   Capture Recommended ECN Details. Record the ECN name, memory, and compute parameters along with the schedule from the recommended configuration.

   Add the ECN. Open Manage Configuration from the Instance Overview page for instance configuration access.

   In the Additional Nodes section, click Add ECNs and input the noted ECN specifics.

   Note

   ECNs start with a status of Running, initiate additions timely to mitigate costs.
3. Configure Recommended Workload Class Routing

   Identify recommended workload classes. Access the list of workload classes slated for ECN routing via the Recommended Configuration section link.

   Assign ECN as routing location. In the instance Overview page view Workload Management access. Verify routing location visibility in Workload Classes Management. Adjust column displays as needed. In Workload Classes, mark desired workload class row, select Edit. Under Workload Routing, choose the ECN from Routing Locations. For setups using asynchronous table replication, activate the ATR toggle per table. (Refer to Asynchronous Table Replication).

4. Note

   Queries default to coordinator processing if ECN routing is unavailable. Multiple workload classes necessitate individual routing location setups, simultaneous edits possible with common parameter settings.

   Consult details on Workload Classes, Routing, Limit settings, and properties for further insight. Optimize coordinator size once temporary workload peaks stabilize per resource usage guidance. Post-recommendation timeframe, deactivate ECNs to avoid excess costs.

The ECN Advisor analyzes workload on the coordinator node and creates recommendations for optimal use of ECNs to reduce coordinator workload. Recommendations include the time range for ECN activation, workload classes to route queries, and ECN capacity. Manual recommendations can address recurring workload peaks by analyzing historical peak periods.

Applying ECN Advisor recommendations involves adding ECNs and configuring workload class routing as advised. Prerequisites include having a recommendation available, necessary roles, and the WORKLOAD ADMIN privilege. Steps include adding ECNs and setting up recommended workload class routing through SAP HANA Cloud Central.

The outcome is that queries suitable for ECN are routed to ECNs, with statement memory and thread limits applied accordingly. Efficient use of ECNs aims to reduce coordinator workload during peak periods.

For more information about the Elastic Compute Node Advisor, see

• Elastic Compute Node Advisor | SAP Help Portal
• Managing Workload with Workload Classes | SAP Help Portal
• Expensive Statements Trace | SAP Help Portal