Share
Report
5Hello everyone,
Hope I got the forum right, otherwise, please let me know.
I would very much appreciate advice from anyone who might have experience with the questions I have:
First. I've read at microsoft.com that read commited snapshot ON is recommend for best performance, I do however wonder:
1) Isn't it 'dangerous'? Don't you risk getting data that is not entirely it to that and wouldn't that be crucial in an application suchs as Axapta, atleast in some of the functions and features it can deliver? (webshop backend, inventory management etc.)
Source:
docs.microsoft.com/.../configure-sql-server-and-storage-settings
2) My customer runs Axapta 2012 R3 CU13, but the SQL Server is 2016, but both the main database and the model database is running compatibilty mode 2012.
According the documentation from Microsoft (see source below), after CU 11, SQL 2016 is supported.
I'm curious to know if by supported, does it mean I can set compatibility mode to 2016 on both the default and model AX2012R3CU13 database and the model database?
And if yes, just as important, can I enable query optimizer (seperate feature, ON or OFF switch) too?
Source:
https://www.microsoft.com/en-us/download/details.aspx?id=11094
Please excuse my limited knowledge of the practical use of Axapta. I'm here to be eduated, willingly.
I hope someone has experience with the above and have the time to share their experience and perhaps educate me a bit.
In any case, thank you for reading, much appreciated.
/Mike
*This post is locked for comments
All responses (
Answers (
