candidates for HANA sidecar usage

[Former Member]

Hello folks - we have a financial landscape running ERP6 EHP4 on Oracle RDBMS, and are considering 2 options

1) once ECC/ERP on HANA is available - migrate to HANA from Oracle (so the entire system would run on HANA)

2) setup a sidecar HANA - and then use it for a select group of tables/processes - to help improve performance against those objects (so data from the ERP system would get pulled into the HANA sidecar and queries/jobs would run against the sidecar instead of the original ERP system itself)

For the 2nd option - is there any SAP service or tool that can help us pinpoint what tables would be the best candidates for use in the sidecar?  I can't find this anywhere but would think SAP would be more than happy to guide customers to anything that gets them using HANA. (the first option is probably more long-term for us BTW)

Thanks

[former_member204796]

Hi Ben,

As you have mentioned, Option 1 should always be the long term approach. However , to leverage the benefits of HANA immediately, suggested approach could be to choose option 2, i.e. HANA is used in side car approach, where in the SAP products - ERP, CRM, SCM etc continue to use classical database , but the table and data in these are replicated to HANA database. This can be done for selected scenarios or select transactions / business processes - ex: - CO-PA or Custom transactions / reports that have huge performance issues.

Following SAP tools can be used to identify potential programs/scenarios for Optimization.

SQLM- SQL Monitor - This logs all the SQL statements that are executed on an ABAP application , would help to identify the programs that have performance issues due to SQL statements. The log for around 1-2 weeks can be checked to identify potential areas of optimization.

SWLT- Performance Tuning Worklist    - Used to combine static check results with SQLM snapshot to identify the hotspots  within programs. We can use this tool in the production system for few days to identify the programs/transactions that need optimization.

Enhanced SCI- Code Inspector  - this tool can be used to perform Static checks within ABAP programs and identify code patterns that could be optimized. This can be very useful for Custom ABAP programs and can be readily used in dev/quality systems as well.

SAP also suggests the use of  Business scenario recommendations report for SAP Business Suite powered by SAP HANA, This report identifies the specific business value scenarios most relevant to you after analyzing your current production usage and your productive SAP landscape. Although this is suggested for option 1, same can be used to identify potential areas of Optimization. Details of the same can be found on www.suiteonhana.com , you will need to upload your production log details so that you can receive your results report by email. The site also has a sample report.

Regards,

Suma