Conference ulysse::rdb_vms_competition

1156.0. "Ingres server debugging?!?!?!" by TRCOA::MCMULLEN (Ken McMullen) Wed May 27 1992 22:48

    I need some help/recommendations on how do you debug/determine what an
    Ingres database server is doing. Let me explain.
    
    We have a customer that has implemented an application on a VAX 9000
    that was developed using ABF and an Ingres database. The expectations
    were to support over 200 active users on the system. They only get
    about 60-70 users (which generate about 160 processes - oh those lovely
    Ingres sub-processes) before the CPU is 100% busy. The average I/O rate
    for the system is less than 50 (even my 780 can do that), and according
    to the customer locking is not an issue. My customer does not know how
    to determine what the database servers are doing. The servers account
    for over 80% of the CPU workload (measured by VPA and monitor).
    
    If the application is not too complex and that there is a reasonable
    database design for the expected workload, how do we determine what the
    database server is doing? My customer says Ingres does not have tools
    for this type of work. They are running Ingres 6.3 and VMS 5.4
    
    I know we must look at the application. It could be possible that the
    transactions are very complex and the workload being generated by 60
    users may saturate a 9000.
    
    Any suggestions from any Ingres gurus will be appreciated. You may even
    win an all expense paid trip to beautiful Toronto (home of baseball's 
    league leading Blue Jays).
    
    I am trying to contact Ingres, but the Ingres support in Toronto is as
    good as everywhere else.
    
    Ken