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 DBA authority, or as a user who has been assigned EXECUTE permission on the sp_iqmpxinfo procedure.
  2. Run sp_iqmpxinfo.
Related reference
sp_iqmpxinfo Procedure