Is a log file available where we can see information about user and disk accesses?
We have a problem that some of users data requests are running very slow. To try to identify these processes we can use the information of the disk accesses.
Our ERP programme uses Pervasive. Some Processes in the ERP system are marked as heavy bij our ERP supplier. So we can organize to do these processing scheduled at night.
But being marked as heavy is one thing we also want to see in the system that it costs performance.
Another thing is the reporting tool within the ERP system. The Reporting tool Crystal Report is embedded and sometimes you have to wait for almost 5 minutes to get your data on screen and sometimes it shows up immediately.
Question is why it is taking so much time while in fact it isn't necessary.Apparently another process is going on I we want to monitore which.
We have a couple of parameters which I have monitored during the working day.
- % Processor Time - Doing a task Average=48%, Regular tasks=32
- Pages per sec. - Doing a task = 100%, Regular tasks=almost nothing
- Avg. disk queue length = almost nothing to 10%
We have the ERP system running on a virtual server.
Regularly we have to wait on the server for response for a couple of minutes. Can somebody tell if our server is slow on the information given.
My guess is that the Crystal Reports are either not using indexes or, when they are fast, are using cached data.
It's also possible that the ERP program is just doing more processing than you are expecting.
You said the ERP is running on a virtual server. What are the CPU and RAM properties? What are your Pervasive settings? Have you tried some of the Pervasive tools? Do they show the same slowness the ERP program sees? Have you contacted the ERP vendor?
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.