on 12-25-2014 3:35 PM
Hi All,
I am new to SAP HANA, I have given a report to check the performance in HANA whose performance is bad in CRM server, I don't know where to start. could anyone please let us know the step by step procedure from starting. I have installed HANA studio.
Please suggest.
Regards
Dear Saurabh,
You do not always need HANA studio in order to analyze the performance of ABAP report for HANA DB.
You can analyze the performance of the ABAP report using standard runtime performance analysis tools like
You can use the Code Inspector with the performance variant PERFORMANCE_DB to find out important static check findings wrt performance.
Once you have analyzed the performance bottlenecks you may use many of the available code push down techniques like Open SQL, CDS or AMDP in order optimize your ABAP report. Please refer to the following blog to get an overview of many of the available code push down techniques.
You may also find this blog on ABAP custom code optimization interesting and useful.
Hope this information is helpful. Please do visit the ABAP for SAP HANA community for more information.
Best regards
Sundar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Partik,
I have checked the document but still not able to understand from where to start. Please suggest
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Saurabh,
To check the performance of a report, you need to run ATC(ABAP test cockpit) and check with a variant PERFORMANCE_DB. After running, you shall get a list of errors as well as suggestions as how to solve each error. To run ATC, there is one document which elaborates and depicts everything which you shall require. Please go through the given link
I hope this helps.
Cheers,
Sumit
Hi Saurabh,
Yes you can perform ATC check in both studio as well as SAP HANA GUI. If you are using HANA Studio, you need to have ABAP perspective where you are writing or using the report. so you can open the report and click on ATC from menu option with PERFORMANCE_DB variant and it will give you all performance related errors. Same thing can be done using SAP GUI as well.
Cheers,
Sumit
Hi Saurabh ,
You can always go through the documentation.
SAP HANA Platform – SAP Help Portal Page is a beautiful link to the hana documentation.
Performance tuning guide is also available there.
Go through the below mentioned link it will definitely help you.
Hope this helps.
--
Pratik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.