sp_cluster connection, migrate_status

Description

Determines if previous connection migrations to a new instance are pending.

Syntax

sp_cluster connection, ‘migrate_status’ [, ‘spid_list’ ]

Parameters

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.

Examples

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