We have crm-2015 on-prem, inplace and running and causing lot of deadlocks when someone tries to update anything in batch and same time if multiple users are reading those activities.
We are planning to turn on RCSI. I already did on DEV. server and tested and didn't get any locks, but I know that's not the right and only test.
My questions to all experts here is,
- Current size of DB is 40 GB, how hard is to turn that option now to ON.
- Once we turn on, can we turn back off using the same procedure stopping all the services making DB with one active transaction only and then execute ALTER DB command with set option to OFF.
- I also read that some code changes requires but in existing application what to inform our developers about changing the code, or it is best to do all operations which we are performing and see if anything breaks.
- last but I guess this most important once we turn on does tempdb database version store cleanup happens by itself or do we have to turn on, if we have to from where?