Compressing an SAP database using report MSSCOMPRESS

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Compressing-an-SAP-database-using-report-MSSCOMPRESS/ba-p/367046 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html SAP released the report MSSCOMPRESS in SAP note 1488135. The report can be used to compress existing tables and indexes using the data compression feature of SQL…


Choosing SQL Server compression type for SAP

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Choosing-SQL-Server-compression-type-for-SAP/ba-p/367005 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html Depending on the SAP and SQL Server release, there are different compression types supported by SAP NetWeaver. Unfortunately the naming convention used by SAP and Microsoft is…