Page compression vs. row compression - 30 % savings

[Former Member]

According to

Note 1143246 - R3load: row compression as default for SQL 2008

R3load uses row compression (starting with a certain patchlevel).

I built up a system using TDMS (ERP 6.0 with EHP4) with row compression, target system size was ~ 550 GB. If I built the same system using page compression (by changing DBMSS.TPL during R3load) the system uses only 300 GB.

As of now, is page compression supported and will there be a standard way in building systems using page compression (e. g. an R3load option?)

Markus

[Former Member]

Hi Markus,

Please check the following note:

Note 991014 - Row Compression/Vardecimal on SQL Server

> Page Compression:

>

> With SQL Server 2008 "Page Compression" was introduced, as well. Here the whole data page will be compressed, not

> just row by row as with "Row Compression".

> Page compression is not the standard for SAP and it's currently still under investigation.

> Page compression is supported from the ABAP/4 dictionary and we did not see or do expect any problems in that area.

> But you should still first test page compression for your application before you go productive with it.

Regards,

Federico Biavati

[markus_doehr2]

Hi Frederico,

I know that note.

My question was more in the direction that if it's planned (for the future) to have a choice between row and page compression during load time.

Markus