Determines if previous connection migrations to a new instance are pending.
sp_cluster connection, ‘migrate_status’ [, ‘spid_list’ ]
migrate_status – indicates you are investigating the status of connection migrations.
spid_list – is the list of spids you are migrating. Separate multiple spids with semicolons.
Checks the status of migrated connections for connections with a spid value of 73:
sp_cluster connection, ‘migrate_status’, ‘73’
SPID LogicalCluster Instance ------------ -------------- --------MigrationLogicalCluster MigrationInstance Command ----------------------- ----------------- ----------------- 73 SystemLC ase1 SalesLC ase3 connection migrate