I installed pervasive 2000i svpk4 with win2000 (WTS) 10 users (Xeon
2.8Ghz Dual CPU 3G RAM.
Each session run the same application and the performance is correct
until a session call a "heavy duty" task. (Create a temporary btrieve
file and build a crystal report). When the the heavy task is running,
some others sessions lost performance, especially when the session is
not use for a moment.

Have you know parameters of pervasive to protect performance?
Is it a good way to try downgrade priority of heavy task?
Have others tips?

Thanks.

That sounds like normal behavior.
I am guessing that when the "heavy" task is being run it pushes the
other sessions' (especially idle ones) data out of cache.

It may be possible to do some tuning to reduce the amount of idle data
pushed out of cache (increase the size of the database cache).
It may be possible to bump the number of threads slightly to ensure
that the engine is not waiting on a thread to become available to run
work. Since you mention a single user running a single report at / on
the server the default thread settings should be fine though. Try
increasing the background worker threads to 16.

Leonard

On 19 Apr 2004 14:31:59 -0700, ddion (AT) infopharm (DOT) ca (danny_dion) wrote:

The problem was "The avg queuing write" was 100% used and keep 100%
during the heavy job.
I upgraded to Pervasive V8 and the peak of 100% is very short and
rarely.
Thank.