Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Speeding up full backup of Replicate database ASE 15.5

Greetings all

I need to speed up replicate database backup.

ASE version 15.5

Adaptive Server Enterprise/15.5/EBF 20633 SMP ESD#5.2/P/RS6000/AIX 5.3/asear155/2602/64-bit/FBO/Sun Dec  9 11:59:29 2012

Backup Server/15.5/EBF 20633 ESD#5.2/P/RS6000/AIX 5.3/asear155/3350/32-bit/OPT/Sun Dec  9 08:34:37 2012

RS version

Replication Server/15.7.1/EBF 21656 SP110 rs1571sp110/RS6000/AIX 5.3/1/OPT64/Wed Sep 11 12:46:38 2013

Primary database is 1.9 TB about 85% occupied

Replicate database is same size but used about 32%  (mostly dbo tables are replicated)

As noted above backup sever is 32 bit on AIX.

SIMILARITIES

Both servers use SAN with locally mounted folder for backup files/stripes.

Databases are on  'raw' devices for data and log

Both backup servers have the similar RUN files with following

-N25 \

-C20 \

-M/sybase/15/ASE-15_0/bin/sybmultbuf \

-m2000 \

Number of stripes are 20 for both primary and replicate databases.

DIFFERENCES

Replicate has less memory and less number of engines.

Devices on primary are mostly 32 GB and those on replicate are mostly 128 GB

OBSERVATIONS

Full Back up times on primary consistently about 1 hour.

Full Back up times on replicate are consistently double that (120 to 130 minutes).

Full Backup with suspended  replication or with minimal activity does not reduce the run times much.

What do I need to capture to pinpoint cause of the slow backup on replicate side ?

Thanks in advance

Avinash

Not what you were looking for? View more on this topic or Ask a question