estimate update statements duration

195 Views

Good afternoon and happy new year to all of you,

I'm working for a software company, more precisely in a team in charge of upgrading clients from version A to version B.

This upgrade implies DDL statements and DML statements and I'm often asked for an ETA for different tasks. Classical example would be

- Hi Simon, where do we stand in the upgrade process

- Well now we're running an update statement on table A (statement can used several tables) for about 2h

- OK do you have an ETA for the end of the update or the end of the upgrade?...

Today I'm interested in update statements and I'd like to know if you have any recipe that could help me the 'estimated' duration of an update.

I came to this question because I accidentaly "Crtl-C" and update in progress and it immediately ROLLBACK

I know that since Sybase 12.5.2 9 (I think) you can use command

kill <spid> with statusonly

to have an idea of the duration of the rollback

Therefore I'm just wondering how I could estimate the duration or the remaining duration of my upgrade.

Regards

--Simon