AX2012R/SQLServer 2012 Data compression feedback

Category: dynamics crm deployment

Question

Frederic Blondin on Tue, 06 Sep 2016 06:19:23


Hi,

You are using a 1,4TB AX 2012R2 database on SQL Server 2012 and we consider data compression based on the size and read/write ratio of each index.

After the first tests, AX traitments takes longer with ROW/PAGE compression enabled.

Any positive/negative feedbacks on the same user projects ?

Thks

Fred