Maximum buffer size

(0) Share

Report

Posted on by Community Member

i'm facing an error " Alternatively, you have to specify a 'Maximum buffer size' value of 72 Kbytes or higher on the 'Database Tuning' tab page in the Microsoft Dynamics AX Server Configuration Utility. The default value is 24 Kbytes"

while i'm create new Vendor and i'm go to Server Configuration but i don't know any field do need change and i need know reason this error

kindly assist me to solve this error

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Sohaib Cheema 49,664 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

In AX Server configuration you can create a new configuration as you cannot modify standard configuration.

muhammadnazim.blogspot.com/.../how-to-increase-maximum-buffer-size-in.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

New Server Configuration not enabled

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Server configuration is a stand alone utility and could not be opened from AX. Usually it could be found Start > Administrative Tools > Microsoft Dynamics AX 2012 Server Configuration.

Please refer to this msdn article technet.microsoft.com/.../aa569618.aspx

Was this reply helpful? Yes No
André Arnaud de Cal... 304,932 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohamed,

Can you also indicate what query makes this large size? The default Maximum buffer size had been increased to 48 Kbytes as of AX 2012 R2. I have never seen a requirement for 72 Kbytes before. So I'm interested what causes this...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

It was increased Maximum buffer size and solve problem, but I am very concerned in terms of performance

Was this reply helpful? Yes No
André Arnaud de Cal... 304,932 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohamed,

The performance is also my concern. Can you review my previous question to provide some insights on this query?

Was this reply helpful? Yes No
ShaikhAtif 201 on at

Like (0)

Report
Copy link

Link copied!

Without create new configuration can increase buffer size ?

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (1)

Report
Copy link

Link copied!

It is possible, you need to edit the registry key called sqlbuffer, since the client/server configuration tools are just editing the registry values.

It would be somewhere here, using regedit:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Dynamics Server\6.0\01\Original (installed configuration)\sqlbuffer

Was this reply helpful? Yes No
Suggested answer

Ajit 8,788 on at

Like (1)

Report
Copy link

Link copied!

We should review the query and try to optimize before increasing the buffer size

Was this reply helpful? Yes No