Skip to Content
0
Former Member
Jan 03, 2014 at 03:53 PM

estimate update statements duration

161 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