Load of ASE database taking longer time .

955 Views

Hi Everyone :

We tried to load one of the user database which size is 280 GB using the 150GB databases dump ( Ie. Load of 280 GB database with dump taken out from DB which is size 150GB ).

Message : " All dumped pages have been loaded. ASE is now clearing pages above page 38400000, which were not present in the database just loaded. "

But above clean up of extra space took 7 hours and it didn't complete after 7 hours( only 70 % got completed )

Fyi - Backup server allocated memory for both source and destination server remains same . and during this operation there was no activity in server (Idle state ) .

( In the end , We cancelled the LOAD job and loaded the same database with 280 GB database dump. This operation in total ,took 30 mins ) and

There was no active transaction in the source database while we collected the dump ( ie 150 GB database dump ) .

1) We would like to understand ,

Why this cleanup taking so long ?

2) Is ther any way to make this cleanup faster