sp_iqmpxincstatistics Procedure

Displays a snapshot of the aggregate statistics of internode communication (INC) status since server startup as of the moment of execution.

Syntax

sp_iqmpxincstatistics

Applies to

Multiplex only.

Privileges

Requires the MANAGE ANY STATISTICS system privilege. Users without MANAGE ANY STATISTICS system privilege must be granted EXECUTE permission.

Description

Returns:

sp_iqmpxincstatistics Columns
Column Name	Data Type	Description
stat_name	char(128)	INC statistics name
stat_value	unsigned integer	INC statistics value

Valid stat_name Values
Value	Description
NumSuspendedINC	Number of suspended INC connections since server startup
NumResumedINC	Number of resumed INC connections since server startup
NumDroppedSuspendedINC	Number of dropped INC connections that have been suspended (on coordinator only)
NumSuspendedTxnRollbackINC	Number of rolled back global DML transactions due to INC failure (on writer only)

Example

Shows one suspended and one resumed transaction:

sp_iqmpxincstatistics 
stat_name                   stat_value
NumSuspendedINC             1
NumResumedINC               1
NumSuspendedTXNRollBackINC  0