2
Currently, MS Dynamics CRM has databases that are very bloated.
According my investigations data of CRM on-premise and behavior of CRM online, this is because default fill factor equal 20 on all indexes (including clustered) that increases size of all tables in 5 times.
Additionally, a data compression on database level is not implemented.
So the idea is to do some performance investigations about increasing fill factor (increase it ,for example, to 80) and implementing a data compression - how it will affect other aspects.
After that, implement tools for admins to set this values in supportable way (for on-premise and on-line versions).
Implementation of this idea will have a lot of benefits:
* performance - at least data selection will be more quickly
* reasonable usage of hardware - less disc space will be used for databases and backups
* customer satisfaction - lower cost for customers that use CRM Online and have huge databases
According my investigations data of CRM on-premise and behavior of CRM online, this is because default fill factor equal 20 on all indexes (including clustered) that increases size of all tables in 5 times.
Additionally, a data compression on database level is not implemented.
So the idea is to do some performance investigations about increasing fill factor (increase it ,for example, to 80) and implementing a data compression - how it will affect other aspects.
After that, implement tools for admins to set this values in supportable way (for on-premise and on-line versions).
Implementation of this idea will have a lot of benefits:
* performance - at least data selection will be more quickly
* reasonable usage of hardware - less disc space will be used for databases and backups
* customer satisfaction - lower cost for customers that use CRM Online and have huge databases
STATUS DETAILS
Needs Votes