HANA SQL Query result size

[Abhinav_Sharma]

Hi Gurus,

I am running a HANA query from PowerBI and it is hitting the HANA Calculation view. I am interested to find out the memory size of the HANA query result set.

When I run the SQL trace, I am getting the query that is hit along with the parameter,however, I am not getting the result set size in terms of memory consumption.

Can you please guide me which system view to be used for the memory size as so far I am not able to find any information on the same?

Thanks!

Abhi

[deodutt_dwivedi]

Hi Abhi,

In case you are not getting out of memory error, copy paste the query in SQL Console in HANA Studio. Right click -> Visualize Plan --> Execute. It will show you the memory stats along with other details.

Regards,

Deo

[Abhinav_Sharma]

Thanks Deo,

Just a follow-up question. Is that the only way? If I run the Visual Plan -> Execute, I am getting memory allocated as 25 GB for over 130K records. I dont think this would be the size of the result set.

Is there any other way to get only the size of the result set for HANA query, like how much size is for 130K records?

Regards

Abhi

[deodutt_dwivedi]

@Abhi - In reply to your comment, Not sure what you are trying to infer from size of result set. Whenever the same query will be triggered from Power BI or anywhere else, it will need, the said 25 GB of memory for processing in HANA. From system views stand point, you can check SYS--> M_SQL_PLAN_CACHE* views for further details of memory and run-time execution.

Regards,

Deo