8,225
Hi All,
we are considering enable RCSI on Production SQL server .can we do it while AX is running ?
and should we increase Temp DB size for before enabling RCSI?
Thanks in Advance,
AP
*This post is locked for comments
I have the same question (0)
READ_COMMITTED_SNAPSHOT must be enabled on the AX database, it is in all documentation and performance checklists:
[View:https://technet.microsoft.com/en-us/library/dd309734.aspx#Configuring%20the%20instance%20of%20SQL%20Server:750:50]
[View:https://blogs.msdn.microsoft.com/axperf/2008/03/13/ax-database-configuration-checklist-part-2/:750:50]
[View:https://blogs.msdn.microsoft.com/axsupport/2015/09/25/ax-performance-analyzing-key-sql-server-configuration-and-database-settings/:750:50]
TempDB size is not too relevant, we are running at 8 x 12 GB data and 10 GB log currently for a 2 TB AX database, from which the used space is at 5% and 35% respectively.
Share
Report
All responses (
Answers (
