Checking Server Status in Interactive SQL

Check the server status to determine if any servers are not responding or not included in the multiplex, and to see which server will be the new coordinator in the event of a failover.

  1. Connect to the coordinator as a user with MANAGE MULTIPLEX system privilege or as a user who has been assigned EXECUTE permission on the sp_iqmpxinfo procedure.
  2. Run sp_iqmpxinfo.
Related reference
sp_iqmpxinfo Procedure