Hi all,
after reading some other posts and blogs it already seems to a be a known issue that the value of the maximum buffer size on the MS Dynamics AX 2012 Server Configuration has to be adjusted in order to be able to open various ListPages and SSRS Reports in AX2012.
On the other hand, it is recommended to increase this value as much as needed, and as little as possible. Following this recommendations i adjusted the maximum buffer size step by step to 30 KB.
Today I found report in the AX standard installation (AX2012 + CU2 + Hotfix-KB2674689) which needs a maximum buffer size of 34 KB if I want to open that report (the name of the report is TaxTransDetail and can be found in the General ledger module under "Reports --> Transactions --> Groupings --> Sales tax transactions - details").
My questions are:
Any help is appreciated.
Thanks a lot,
Franz
*This post is locked for comments
Default is 48 in the server configuration utility.
A bit late but just for completion just in case somebody else lands here:
As the page size is 8KB, the buffer size should be a multiple of 8 to specify how many pages can fit in the cache buffer. Deffault value for R2 and R3 is 12 pages = 96KB
Pir_Rana Thanks for sharing TechNet blogs
------------------------------------------------------------------------------------------
My point is there any more information on (For stability issues a max buffer size should always be a multiple of 8.
Keep in mind.)
--------------------------------------------------------------------------------------
Regards.,
Ravi Theja Madisetty
Hi,
This will help you.
technet.microsoft.com/.../aa569635.aspx
technet.microsoft.com/.../aa569634.aspx
the default Buffer size is 24 kb.You can adjust this value when queries that return a large number or rows are executing slowly.
Hi Wim,
On what basis buffer size should be a multiple of 8 ? Is there any TechNet document explain the same ? or Is this Microsoft suggestion ? Please add your comments.
Regards.,
Ravi Theja Madisetty
Guys,
For stability issues a max buffer size should always be a multiple of 8.
Keep in mind.
Wim.
hi,
I hope below TechNet article will help you on your query. In Ax2012R3 maximum buffer size is 48KB.
blogs.msdn.com/.../random-clients-crashes.aspx
Regards,
Ravi Theja Madisetty
Thanks Franz for the clarification & yeah I have Ax 2012 R2 installed at our place & the default Buffer size is set to 48 KB - that might be because of 2 individual databases - one for Business data & other for Model Store DB (just a guess).
Regards,
Sanjivkumar Kori.
Hi Sanjivkumar,
132 KB for sure is too much as recommended value of max buffer size. We adjusted the max buffer size value "as needed", which means that always when we found a functionality in AX that gave as an error message saying that a greater size is required (most of time it were SSRS reports) we adjusted the buffer size.
At the moment we use a max buffer size of 36 KB, but we are migrating to AX2012 R2. I've seen that the default value of max buffer size in R2 is 48 KB, I think that should be enough for now.
Best regards,
Franz
Hey Franz - let me know if you were able to find the Recommended value of Maximum Buffer Size,
& also is it going to be more than 132 KB?
& also the environment in question is Production....
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156