DataBase Tab on AOS Configuration

sinhaAnil

Hi,

Can Axapta performance be improved by setting DataBase Tab on AOS Configuration Screen?

What should be the best possible setup for the following fields on DataBase Tab on ASO configuration Screen:

1. Initialize database for unicode
2. Buffer Size
3. Max Open Cursors
4. Retry
5. Max cache sync time

Thanks in advance for help.

Regards
Anil Sinha

Mugur

Hi,

After reading your questions, I accidentally came to the following. For more about Performance, visit http://www.harishm.com/Navision/Performance.html.

"1. Why my system is very slow ?

If the Axapta Configuration Utility (axconfig) is set to 'Initialize database for Unicode', then the Axapta kernel (both AOT or 2-tier client) would instruct the SQL Server ODBC driver that string search criteria should be converted from VARCHAR to NVARCHAR. This results in severe performance degradation if the database was in fact not initialized for Unicode, because string columns are then in fact VARCHAR, which will have the SQL Server conclude that index on the VARCHAR columns are less than useful.

The answer would be to set the Axconfig parameter 'Initialize database for unicode' to how the database was in fact initialized. In other words, ensure that AxConfig and the database setting matches. By the way, if the used database is an upgraded Axapta 2.5 database, then it was NOT initiliazed for unicode. "

Regards,
Ciprian