Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2010
    Posts
    2

    Unanswered: dump database is taking ages to complete

    Hi All

    I have situation where the dump database is taking longer to complete,
    usually it take around 1.5 hours for this particular dump db to
    finished but now its taking more than 4 hours. I have checked the logs
    and all seems ok, I cant see any probable cause.

    My question is, is there i way for me to check why the dump database
    is take that long to complete or check the percentage of the dump.
    Also would be good if you guys can point me out to where to check to
    determine the cause of the problem.

    Other info

    ASE : 12.5.3
    OS : Solaris 10

    Thanks
    Al

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Is there something else accessing the disks?
    Are you using compression and something else hogging the CPU?
    How long does it take to copy a large 1G file using the same disks?
    If external disk unit, check that the write cache is still enabled.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    You should be able to tail the backupserver log to make sure that the backup is still running, and get a rough estimate of how many pages have been backed up so far.

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Quote Originally Posted by ae2dba
    is there i way ... check the percentage of the dump
    On databases ≈ 1G and larger, every line of "kilobytes DUMPED" in the backup server log is ≈ 1%. i.e. at the end you should have ≈ 100 lines of "kilobytes DUMPED"

    e.g. If your backup start on line 565 in the log file then this should give you a close enough %done
    Code:
    tail +565 ASE-12_5/install/mysrv_back.log | grep 'kilobytes DUMPED' | wc -l

  5. #5
    Join Date
    Mar 2010
    Posts
    2
    Thanks for your reply, I have found the where the problem lies... One of the SAN divice is faulty can causing problem with the write.

    Thanks again

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
  •