Performance PSQL 10

Hi,

We have just upgraded a customer from Pervasive 2000 to Pervasive 10. This customer is now reporting, 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

.

Relevant Pages