Regarding Calculation performance differences in DEV and PROD

[Former Member]

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

[lbreddemann]

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]

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

[Former Member]

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

[lucas_oliveira]

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

[yakcinar]

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

[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

[Former Member]

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

Its been 15 min still running