Skip to Content
avatar image
-1
Former Member

Regarding Calculation performance differences in DEV and PROD

Hi All,

We have build a calculation view, this view have MSEG table, other calculation views and attribute views .

This view responding too long for data preview in PROD system compare to DEV system as per given screens.

I couldn't unable to find the reason for this strange behaviour. Please suggest me how can solve this issue and how to improve the performance of this view.

DEV

PROD

Thank In Advance

Kohli

dev.png (27.4 kB)
prod.png (32.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • This question lacks a log of required minimum level of information.

    • What version of SAP HANA are you using?
    • What does the SQL look like?
    • What are the differences in the system hardware?
    • How much data is in the tables accessed?
    • What does the EXPLAIN PLAN look like?
    • What does the PlanViz look like? You can limit the number of records fetched by PlanViz similar to the limitation in the SQL Editor (Preferences menu).

    Please provide the required information and make sure the systems had been configured according to SAP recommendations.

  • Former Member Lars Breddemann

    Hi Lars, sorry for late reply. Here I am providing more details

    What version of SAP HANA are you using? - we are using version 2.2.8

    What does the SQL look like? - this is graphical view, the output sql is simple there is no complexity

    What are the differences in the system hardware? I couldn't get this, please let me know what exactly.(All other large views are responding quick)

    What does the EXPLAIN PLAN look like? Please find the explain plan screen for more details

    explain-1.png (16.5 kB)
    explain-2.png (12.6 kB)
  • Former Member Lars Breddemann

    What does the PlanViz look like? You can limit the number of records fetched by PlanViz similar to the limitation in the SQL Editor (Preferences menu).

    Thanks Lars, I selected for 100 records plan viz, couldn't understand exact location , but I Found some time inclusive and Exclusive time for one are showing more, I guess that is the problem but not sure

    viz-1.png (324.7 kB)
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 13, 2016 at 12:58 AM

    Hi,

    This sort of topic has been discussed here quite frequently. In short: if you need to test performance of a query, get the real use scenario

    Data preview 'raw data' option is the worse option for performance evaluation since this will get all the columns you have with no filtering whatsoever. Bad bad choice. See SAP Note 1894854.

    Regards,

    Lucas de Oliveira

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 12, 2016 at 12:46 PM

    Moreover I executed in visual plan to check if there any clue but taking long to opne.

    Its been 15 min still running

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 12, 2016 at 06:48 PM

    Hello Kohli,

    How many rows are there in MSEG table? Can you partition it?

    Can you see something unusual under Performance tab of Hana Studio when you are selecting data?

    Expensive statements? Others running threads, sessions, jobs? Load graphs?

    You can check Runtime information of MSEG data using Catalog --> SAPDID-->Tables -->MSEG --> Context menu --> Open definiton.

    On definition page there is Runtime information. What do you see on this page? All data loaded to memory?

    Regards,

    Yuksel AKCINAR

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Yuksel AKCINAR,

      MSEG table contain 18 Million records, it wasn't partition

      After re loading the MSEG table , now I can see both DEV and PROD are responding same time and in both places the view taking long to respond more than 2 min, whereas other views for same number of records selection taking 45sec

      The run time is showing as per screen

      mseg-2.png (163.2 kB)