speed issues early in the day.

j.belanger

Current config of Database server.
Dual P3 1.26GHz processors
2 Gigs of ram
Visual effects "Adjust for best performance (with nothing checked)
Processor Scheduling "Background Services"
Memory Usage "System Cache"
Virtual Memory 3096MB
Raid 1 0
Database used 88%
Database size 5000000 8%
Licensed Size 65536000
DBMS Cache(KB) 512000
Commit cache (Yes)
Object Cache (KB) 8000
Connection (Server)
Net Type (TCP)

The server was origionally setup for Navision use only, but has the following inistalled on it.
Acronis True Image Enterprise "Agent"
Ad-Aware
Goldmine server
Navision Attain 3.60 server
Symantec Antivirus 10 Corporate Edition


The actual problem seems to only happen when i reboot the server, or early in the morning. Very slow response time, but once each user goes into the screens they use the most, (put in cache) it speeds up for everyone.

Is there a way to speed this up anymore, or is this a known problem? I have tried to setup Indexing for the Navision Database folders, but that didn't seem to do anything noticable.

Any tips would be appreciated. Thank You

kine

It can be problem with the antivirus. When first user is connected, the DB file is opened and the antivirus is checking it. Try to set the antivirus to ignore .FDB files or just try to temporary disable it.

Phenno

kine wrote:

It can be problem with the antivirus. When first user is connected, the DB file is opened and the antivirus is checking it. Try to set the antivirus to ignore .FDB files or just try to temporary disable it.

Duhhh, forget it, Kine already answered.

j.belanger

Which anti virus should I exclude either the entire Navision directory on? the users pc, or the actual Navision Server its self?

kine

You know, that this is problem of server (because it do not depend on from which client you connect as first user...). You can exclude whole directory with NAV server and NAV DB...

j.belanger

As of right now, I have excluded entire directory of Navision on the server side, as well as excluded FDB files on the Server. I also excluded FDB extensions on ALL client machines. Still not seeing much of an increase in speed when accessing the DB. No change, if anything it seems worse than it was. Any other Ideas?

kine

Ok, these problems are mainly connected with "AutoClose" of the server. After las user is disconnected, the DB file is closed and cache is disallocated. When first user is connecting, the FDB file must be opened, cache must be allocated etc. It can lead to many problems like extensive swapping, because the physical memory used for cache is allocated by another processes during the server is in "sleep" mode. The phys. memory must be moved into page file and phys. memory is than allocated for cahce. (please, take it as my assumption, not as fact, it is just what comes to my mind...). You can prevent that by installing Application server and run it. It will be still connected to the server and server will never free the cahce and fdb file. You just needs to create some dummy process for the NAS...

j.belanger

I already have File Server and Application Server installed on the server. I also have an additional hard drive setup for my paging file. There are 3 drives on this server. C,E,F E holds the navision database files and F is my swap disks with a paging file size of 3096 allocated to the drive. C and E have the Paging File turned off which should automatically send anything which needs additional space to the F drive. Am I correct with this assumption?

kine

By Application Server I mean "Navision Application Server" service. Have you this installed?

j.belanger

By installing the application server, will it fix the slowness of a fresh server reboot as well as the early morning slowness? What else needs to be done after the application server is installed? I do not use this currently.

kine

It can solve both (morning slowness because the DB will be still open), and restart slowness, because the NAS (Navision App. server) will be started as a service and will be the first user, who will "wake up" the DB server...

1) You need to have one NAS session in your license. If you have license bought in last 3 or 4 years, it will be ok, you will have one free NAS session...
2) You need to install Navision application server (you need to use Windows Authentication for it!) - how to install and configure is in the manual on install CD...
3) You need to have some dummy process for the NAS - if you are end user, ask your NSC for that, try to clarify what you want and why you want that and ask them for creating some codeunit with timer doing nothing (e.g. Sleep(500) or something like that...). They will tell you the STARTUP parameter you need to set for the NAS to run this process.