cancel
Showing results for 
Search instead for 
Did you mean: 

Performance tuning of report in HANA studio

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

sundaresan_k
Explorer
0 Kudos

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

  1. SAT and ST05 and
  2. ABAP Profiler(please refer to the following document for more information about ABAP profiling )

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


Former Member
0 Kudos

Hi Partik,

I have checked the document but still not able to understand from where to start. Please suggest

Regards

Former Member
0 Kudos

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

ABAP Test Cockpit and Code Inspector in Context of HANA Migration - SQL Performance Monitoring - SAP...

I hope this helps.

Cheers,

Sumit

Former Member
0 Kudos

Hi Sumit,

Thanks for your suggestion. I have one confusion, I have created report using SE38 in HANA GUI, so for testing the performance do I need to perform some step in HANA studio or we can test there in GUI? Also what is the use of ABAP project in HANA studio?

Regards

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Sumit,

I have checked the performance in GUI. Now I have to test same report in Studio, could please let us know the steps to see same report in studio? Also can we use Attribute view or Analytic view to make better performance in same report?

Regards

pratik_doshi2
Participant
0 Kudos

    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