I'm a tech working with a client. To start, this is not a performance issue so much as a process issue. everything is setup correctly. Its a brand new VM, 4 cores 16gb of ram. there are only 5 users.

the problem at hand is  the sqlanywhere process (quickbooksdb 30) on the server is a steady 25%. this bogs down workers trying to use it. It starts up fine. then after 30 minutes, the service spikes to 25% and stays there till everyone closes and the process stops.

I have gone through the tools, the company file is fine according to the program.

Tried all the fixes and tweaks. turned off search features. i can't get that process to go back to 0% or at least under 5%. This problem has been consistent on 2 servers with this data. can there be something wrong with the data that QB tool can't find?