Moveing Metadata or Log Columnstore from Master to Slave or converting to Rowstore ?

[Former Member]

Hi,

are there any counterindications against moveing large Columnstore BW Metadata and/or Columnstore Logtables

to a Slave to have more space on the Master Slave available ?

Are there any counterindications against converting large Columnstore BW Metadata and/or Columnstore Logtables
to Rowstores on the Master to have more InMemory Space available , except that's slower ....?

Thank You !

Martin

[sunny_pahuja2 · Accepted solution]

Hello,

1) Moving large Column store BW Metadata and/or Column store Log tables to Slave: You can consider that but you should make sure that you perform proper house keeping to reduce size of log tables. You can refer to below document for more information:

http://scn.sap.com/docs/DOC-13132

2) Converting large Column store BW Metadata and/or Column store Log tables to Row stores on the Master: You should not do that without proper findings since master node system tables are stored on the master node. And meta data and transaction data is distributed across slave nodes. If you are worried about statistic tables, log tables, object metadata tables etc. then you can perform periodic house keeping tasks to keep the size of these type of tables in control.

Please also refer to SAP note 1855041 for more information.

Thanks

Sunny

[Former Member · Accepted solution]

Hi Sunny,

my issues is to save InMemory Rowore Space for Scaleouts Solutions for really large queries:

For Topic "1)  Moveing large Column store BW Metadata and/or Column store Log tables to Slave":

Consequently it should be possible to move any SAP BW Metadata Table to a Slave
blade to free the master blade completly from Data which is loaded to InMemory  ?

Doe's this need to be SAP certified at all ?

What's the trade of of putting all the SAP BW Metadata to a salve, accept in general terms "performance" ?  Can the performance improvement / deterioration be quantified ?

Should it be necessary to convert SAP BWs rowstore to columnstore to move it to the blade and what for ?

Thank You

Martin

[sunny_pahuja2 · Accepted solution]

I would suggest to refer SAP Note 1767880 - Non-active data concept for BW on SAP HANA DB

Thanks

Sunny