3610003 - DECLARE script leads to peak memory increasing rapidly in the SQL view of SAP Datasphere.

After clicking "Start Data Persistency", the peak memory in the Data Integration Monitor log (accessed by Views Monitor) rapidly escalates. The memory information "XXX GiB of peak memory used in the view persistency runtime" showed in the log is significantly larger than the peak memory without the DECLARE script. For instance, with the script, the peak memory is less than 1 GB, whereas without the script, the peak memory surges to over 30 GB.

SAP Datasphere

KBA , DS-MD-VIW , Views , DS-MD , Modeling (Data Builder) , HAN-CLS-HC , HANA Cloud Services HANA Cloud , Problem