Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2008
    Location
    Netherlands
    Posts
    18

    Unanswered: Pervasive server Monitoring

    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.

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    You don't say what version you are using but if you are using v11, there are Perfmon counters available: http://docs.pervasive.com/products/d...ance.05.2.html

    Beyond that, there is no log file available out of the box. You could write (or have written) a program that uses DTI / DTO to read the Pervasive Monitor stats and write it out to a log.
    Mirtheil Software
    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.

  3. #3
    Join Date
    Mar 2008
    Location
    Netherlands
    Posts
    18
    Sorry,
    We use 10.10.125.000.
    Thanx, we shall see in the Documents from Control Center.

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    This is the docs for DTI:
    http://docs.pervasive.com/products/d...1.2.html#12677
    and DTO:
    http://docs.pervasive.com/products/d...intro.1.1.html

    Either can be used to write a program to get the same statistics as Pervasive Monitor. You could write (or have written) a program to read the Monitor stats and dump it out to a log.

    That being said, if only "some" of the users are slow, it may not be a disk access issue exclusively. What exactly is happening and why do you think it is slow?
    Mirtheil Software
    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.

  5. #5
    Join Date
    Mar 2008
    Location
    Netherlands
    Posts
    18

    Unhappy Pervasive Server Monitoring

    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.

  6. #6
    Join Date
    Mar 2008
    Location
    Netherlands
    Posts
    18

    Red face System Monitor on Server

    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.

  7. #7
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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?
    Mirtheil Software
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •