Server=Win2K3 with 4Xeon/4GB and 15k drives.(dedicated)
I have 300 customer databases. Each has 100 Btrieve DB files averaging 2GB. (400gb total). Currently all on one server. Pervasive averages 9,000 open files and 20,000 handles with around 300 users on the system. CPU around 10%. NTDBSMGR.EXE uses 1.6GB RAM for the caches.
Updating records can take seconds to minutes sometimes and of course is dependent on application and user load.
My conclusion is simply the design of the app relative to the amount of data being utilized has reached the limits of being able to give adequate response times for the users.
Remedy=add more DB servers and separate customers onto different servers? Any other ideas?