SQL Server Transport Upgrade - Non-clustered index in the input queue

This document explains how to patch a system using the SQL Server transport to remove clustered index on the queue table for improved performance.

Upgrade steps

Existing queue tables need to be migrated manually to the new schema. This can be done by executing the following script for each input queue table in the system:

DROP INDEX [Index_RowVersion] ON <schema>.<table> WITH ( ONLINE = ON )

CREATE NONCLUSTERED INDEX Index_RowVersion ON <schema>.<table>
(
    [RowVersion] ASC
)

This will result in dropping the clustered index Index_RowVersion and creating a new non-clustered index with the same name.

New index schema creation script has been introduced in the following patch version of the SQL Server transport:

• 6.0.1
• 5.0.3
• 4.3.2
• 3.1.5