Hi,
We have just upgraded a customer from Pervasive 2000 to Pervasive 10. This
customer is now re****ting, that our application is lagging very often for
5-20 seconds. That means that it looks like the software is not reacting
anymore and all of the sudden it starts working again. This happens about
10
times a day on moreless all of the 50 workstations and it is has not
behaved
like that with PVSW 2000.
The current performance settings are as follows:
Cache Allocation: 409MB
Max Microkernal Memory Usage: 0%
System Cache: on
We have also noted that NTDBSMGR takes about 50% CPU from time to time and
also at the same time we notice about 40 communication threads and about
60
worker threads (These values are going back to 0 after about 5 seconds)
We have checked other installations with near the same setup and never
noticed that high CPU utilization and also note seeing that amount of
threads being used. What can be the reason for that?
We have also tried with System Cache=off and Max Microkernal Memory Usage
=
60 without any changes. Are there any other settings which have impact to
the performance?
Any suggenstions will be very appreciated.
Environment:
Windows Server 2003 Intel Xeon Dual 3,2 GHz
Memory 4GB
Databases: 50 with total amount 108 GB via Transactional Btrieve (largest
single DB=60GB)
Persavive 10 - 50 user
Thanks and regards
Michael
