SAP ECC 6.0 and sqlserver compression

[former_member221093]

Hello,

I Have 4 questions please :

1. I would like to know if there is a list of recommended tables to compress in ECC6.0 ?

2. Are there tables that should be Pages compressed  rather than ROWn  or vise versa ?

3. Row or Page - recommendation for ECC ?  Pros and Cons .

4. Should I just compress the first n tables listed by MSSCOMPRESS program?

Thanks,

Moshe

[Former Member · Accepted solution]

I will give the quick answer. Page is better, sometimes as much as 25% more compression than row. I suggest to play with MSSCOMPRESS and see for yourself. We have tried it on a BW system reduced by 75% and ECC system reduced by 50% using page. 

To be able to realize the best reduction, you need SQL 2008 R2 or SQL 2012 and SAP Basis patch level needed for each.

http://scn.sap.com/community/sqlserver

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

The link to the "Using SQL Server Database Compression with SAP NetWeaver" should help with all question.

[xymanuel]

Hi Moshe,

search http://blogs.msdn.com/b/saponsqlserver/ for SQL Server compression.

There you will find case studies, tips & tricks about all SAP on MSSQL related topics.

Regards

Manuel