NAS running load on server

ashu_gargs

What is load on server while using NAS? How much is the CPU usage etc..

ara3n

It depends on what NAS is doing. If it's doing nothing, then there is no load. But if you want to compare it running something real. It just like running navision client on server. all NAS is a navision client withtout the GUI and it runs as service.

Peter_Wijntjes

Agree, depends on what the NAS is doing.

some things to consider:
1. Prevent long running transactions, Commit as often as possible (not regarding load, but can slow down live clients "waiting for lock to be released").

2. NAS can have its own value for cache, determines amount of memory used.

3. when a timer is used, make sure that timer interval is not too small. This can lead to substantial hit on Database server during idle-time.
consider using a load dependent timer-interval.