Hi
We are using SQL Database…but every time we conncet to the SQL SERVER…the performance is very slow…why is that happen…do I need to Adjust/increase the OBJECT CACHE in NAV or It is the SQL server. Hoping for your reply 
Hi!
Well, NAV/SQL Performance is a frequently … better permanently … discussed issue in this forum. Please search the forum for “SQL Performance” and you’ll get TONS of useful advices and recommendations!
Regarding the “Object Cache”: The default setting is 32MB which is quite OK. This memory space is used to cache the binary “Object” information (Tables, Forms, Reports, etc.) not for the data itself. Hence, the “Object Cache” size should - theoretically - be the sum of the bytes of field “BLOB Reference” (table “Object”) of all objects used by a NAV user. Again, 32MB represents are good value. If you have users using plenty of objects (and maybe large objects) and you have enough spare RAM (client site) then you could increase it, but 50MB should be the absolute maximum.
Anyway, the Object Cache has just minor impact on the performance, there are much more things to be done!
HI,
If your performance is slow during login, it may caused by active directory user authentication.