Hi,

We used to perform DB refresh on a daily basis. Load usually takes 3 hrs to complete on weekdays. But on Sunday load is taking almost 12 hours to complete. recently we migrated from ASE 12.5 to ASE 15.0. Please let me know what are the steps that need to be followed for investigating this issue.Moreover there is no maintenance on this server.

1. Please check if there was any change in the loading script (change in no of stripes etc)
2. Please check backup server log to see what else was going on?
3. Please check vmstat/prstat data at OS level to see if you were running out of resources?

Is this problem arised after migration from 12.5 to 15. add "set comapatibilty_mode on" on your script and check if you get some benefit. setting this mode on will use optimizer options of 12.5.

Gopal,

Are you talking about the optimizer - compatibility mode in Sybase 15? I don't think it is applicable here.
Loading is carried out by backup server, not dataserver.

Hi John,

I am new to Sybase. Could you please let me know how to check for no of stripes, backup server log?

(02-21-2012 01:07 PM)raograjiv Wrote:  Hi John,

I am new to Sybase. Could you please let me know how to check for no of stripes, backup server log?

edit your script and check if there
dump database databasename to "location\dmp.dmp"
stripe on "location\dmp1.dmp"
stripe on "location\dmp2.dmp"
stripe on "location\dmp3.dmp"