[HPADM] perf problem

From: HAUTECOEUR Bruno (HAUTECOB_at_ESSILOR.fr)
Date: 09/22/04

  • Next message: Wolfgang Leideck: "[HPADM] IBM Shark with MCserviceguard" 
    To: hpadm <hpux-admin@dutchworks.nl>
Date: Wed, 22 Sep 2004 15:55:04 +0200

    Hi admins

    we have a performances problem with an oracle database. This problem came
    suddenly since the last reboot of the server on last monday morning.
    A batch processing which took about 30 min take now about 4 hours !!! This
    batch is only reading all the daily TP to extract data and send them to
    another server.

    I have search for un disk problem but this not the case. The file system is
    alone in a volume group and is mirrored with lvm.
    There is no SCSI error msg, STM say all hardware is correct.
    The 2 disks (primary and mirror) have a service rate of 100% during the 4
    hours of batch. Amazing !!!

    The dba's say that nothing has been modified in the request. Nothing has
    been modified on the system (no patches etc ...).

    HP doesn't find any reason of this sudden strange behaviour.

    The server is a N4000, HP-UX 11.00 64bit. There is no swap at all.

    Have you ever faced to such a problem ? Or do you have any ideas where to
    look for a piece of explication ?

    tia

    regards

    ________________
    Bruno HAUTECOEUR
    Architecte système Unix
    DSI / Architecture & Systèmes - Essilor International
    Tel: 33 (0)1 72 94 73 20 - Fax: 01 39 26 53 08
    mail: hautecob@essilor.fr 

    --
             ---> Please post QUESTIONS and SUMMARIES only!! <---
        To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
       Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
 
 Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
            http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)
  • Next message: Wolfgang Leideck: "[HPADM] IBM Shark with MCserviceguard"

    Relevant Pages

    • RE: Secure FTP Client
      ... If you desire to use scp/sftp transfers in an unattended batch script ... server is authenticated by providing its public key and most software ... asks you to confirm it by displaying its fingerprint. ...
      (Security-Basics)
    • Re: Running Scheduled Tasks Remotely Without Full Administrator Ri
      ... It seems that in order to CREATE a task, one must be an administrator. ... What if you give the user "Run as Batch" right explicitly? ... try to create the scheduled task with the test user. ... MCSA Windows 2003 server ...
      (microsoft.public.windows.server.general)
    • Re: Global variables and DTS Packages
      ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > different servers whenever a batch is paid-off. ... > VB6 application to DTS package which will create a SQL ...
      (microsoft.public.sqlserver.dts)
    • Re: Batches
      ... As Tibor stated it will be one batch and not 7000 individual round trips. ... building a single string I could have answered that more appropriately. ... > This is just the standard method of the built in .NET SQL Server data> provider. ...
      (microsoft.public.sqlserver.programming)
    • Re: Checkpoint causes need for better IO subsystem?
      ... seconds typically matches the duration of a normal checkpoint. ... you may benefit from more physical RAM in the server. ... It's during pereids of batch inserts that this happens which occurs many ... transfered over all of the hard drives, that during these batch inserts, ...
      (microsoft.public.sqlserver.tools)