Переход на SQL 2005

[ZVV]

Но у меня sp3 kr1

А если у вас kr2, то читайте описание фиксов к KR2:

Цитата:

Poor performance of kernel installed on Oracle based Axapta systems
post OCC (Optimistic Concurrency Checking) implementation.
· Problem
The process of creating RECVERSION columns on database upgrade took
very much time on Oracle database. The problem was with SQL statement used
for creating RECVERSION columns: it used "ALTER TABLE ... ADD RECVERSION INT
DEFAULT 1" statment causing Oracle to actually allocate space for new column
in all table rows and fill that column with default value.
· Solution
The fix is to use "ALTER TABLE ... ADD RECVERSION INT" statement so
that Oracle would create columns using default NULL value. This way space
wouldn't need to be allocated at once for all table rows.